counter
 

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.

counter
 

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.

counter
 

Yeah, just so I mean,
Thanks Dave!

"Dave O" skrev:

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.