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.

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.

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.
>
>