Number increments

mbruggemann · Apr 14, 2006

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 · Apr 14, 2006

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
[email protected]
"mbruggemann" <[email protected]>
wrote in message
news:[email protected]...