Increasing Number

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

Thank You

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.
--
Gary's Student


"David" wrote:

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

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

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

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"David" <[email protected]> wrote in message
news:[email protected]...
> Hello, is there anyway I can get a number in my spreadsheet to increase
> when
> I print my document.
>
> Thank You
>
>