counter

H

Haza

Please somebody!
I wount a visible counter to one of the cells that counts how many papers i
print out.
The first paper 1, second 2 and so on.
 
D

Dave O

This can be done by recording your print macro, and then a line to the
macro the increments the value of a particular cell by 1. This
provides the counter mechanism you're looking for.

The line to add to your macro is
Range("sheet1!a1").Value = Range("sheet1!a1").Value + 1

Where your counter is located on Sheet1 cell A1. You can change this
to match your sprdsht, of course.
 
Top