Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing Number
Hello, is there anyway I can get a number in my spreadsheet to increase when
I print my document. Thank You |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing Number
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing Number
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" wrote in message ... Hello, is there anyway I can get a number in my spreadsheet to increase when I print my document. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number format | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions |