Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counter
Where is the code and what do you have written ?
if you add this to ThisWorkBook for example Private Sub Workbook_Open() Sheet1.Cells(1, 1).Value = Sheet1.Cells(1, 1).Value + 1 End Sub It will add a value to the first cell in the workbook and each time the workbook is opened the value will be incremented by 1. Mark D "Andrew" wrote in message ... Everytime my workbook opens, I want a new number assigned to a worksheet, simply 1 plus the last number. I keep getting a circular reference. Any ideas? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Day counter | Excel Discussion (Misc queries) | |||
How do i set up a counter? | Excel Discussion (Misc queries) | |||
counter | Excel Discussion (Misc queries) | |||
Counter | Excel Discussion (Misc queries) | |||
Counter | Excel Programming |