Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counter
Please somebody!
I wount a visible counter to one of the cells that counts how many papers i print out. The first paper 1, second 2 and so on. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counter
This can be done by recording your print macro, and then a line to the
macro the increments the value of a particular cell by 1. This provides the counter mechanism you're looking for. The line to add to your macro is Range("sheet1!a1").Value = Range("sheet1!a1").Value + 1 Where your counter is located on Sheet1 cell A1. You can change this to match your sprdsht, of course. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counter
Yeah, just so I mean,
Thanks Dave! "Dave O" skrev: This can be done by recording your print macro, and then a line to the macro the increments the value of a particular cell by 1. This provides the counter mechanism you're looking for. The line to add to your macro is Range("sheet1!a1").Value = Range("sheet1!a1").Value + 1 Where your counter is located on Sheet1 cell A1. You can change this to match your sprdsht, of course. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I determine the number of cell formats in this workbook | Excel Discussion (Misc queries) | |||
Did I stump everyone? Counter that ignores hidden rows | Excel Discussion (Misc queries) | |||
Creating a counter that does not include hidden rows | Excel Discussion (Misc queries) | |||
Row counter in formula | Excel Worksheet Functions | |||
Increment a counter in Excel | Excel Worksheet Functions |