| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic counter or auto-increment
I'd like to have a counter where each time I access a worksheet (ExcelXP) it increments by one (just like the ol' Invoice in Excel 2000 and 97) or each time I send it to print (this would be even better). Any ideas?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
automatic counter or auto-increment
use the BeforePrint event to increment a counter stored in a defined name or
in a cell. To be successful, you would need to save the file after you updated the counter. -- Regards, Tom Ogilvy "Jjt" wrote in message ... I'd like to have a counter where each time I access a worksheet (ExcelXP) it increments by one (just like the ol' Invoice in Excel 2000 and 97) or each time I send it to print (this would be even better). Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set an automatic working days counter | Setting up and Configuration of Excel | |||
| auto increment | Excel Discussion (Misc queries) | |||
| stop automatic increment of dates | Excel Discussion (Misc queries) | |||
| Increment a counter in Excel | Excel Worksheet Functions | |||
| How do I input for an automatic increment in a cell on Excel? | Excel Worksheet Functions | |||
Hybrid Mode
