Increasing Number

D

David

Hello, is there anyway I can get a number in my spreadsheet to increase when
I print my document.

Thank You
 
G

Gary''s Student

Yes. There are two cases. Let's say you have the number 15 in cell A1.


If you want to increase the number before you print, then click on the cell
and enter 16 prior to printing.

If you want to increase the number after you print, print the worksheet then
click on the cell and enter 16.
 
D

Dana DeLouis

This code may work if you place it in the "ThisWorkbook" module.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
[A1] = [A1] + 1
End Sub
 
Top