Printing Macro-I open the file

[[email protected]]

I would the number in cell "a3" to increase by 1 for each page printed.
In addition, it should also save the last number to continue the next
time I open the file.

Thx

[Tom Ogilvy]

Look at the beforeprint event

http://www.cpearson.com/excel/events.htm

there is no afterprint event.

--
Regards,
Tom Ogilvy



"[email protected]" wrote:

> I would the number in cell "a3" to increase by 1 for each page printed.
> In addition, it should also save the last number to continue the next
> time I open the file.
>
> Thx
>
>

[Tom Ogilvy]

Look at the beforeprint event

http://www.cpearson.com/excel/events.htm

there is no afterprint event.

--
Regards,
Tom Ogilvy



"[email protected]" wrote:

> I would the number in cell "a3" to increase by 1 for each page printed.
> In addition, it should also save the last number to continue the next
> time I open the file.
>
> Thx
>
>

[Tom Ogilvy]

Look at the beforeprint event

http://www.cpearson.com/excel/events.htm

there is no afterprint event.

--
Regards,
Tom Ogilvy



"[email protected]" wrote:

> I would the number in cell "a3" to increase by 1 for each page printed.
> In addition, it should also save the last number to continue the next
> time I open the file.
>
> Thx
>
>