Number increments

[mbruggemann]

I have an excel spreadsheet with one cell that needs to be incremented
by 1 every time it prints. So the first printout should read 1 the
second 2 etc.. Any help is appreciated..

Thanks,
Melissa

 

[Don Guillett]

Use a before_print event in the ThisWorkbook module to add 1 to a cell
somewhere.
sheets("sheet2").range("a1").value=sheets("sheet2").range("a1")+1

--
Don Guillett
SalesAid Software
(e-mail address removed)
"mbruggemann" <[email protected]>
wrote in message
news:[email protected]...