counter in worksheet

  • Thread starter Thread starter knausen
  • Start date Start date
K

knausen

Hello
Is there posible to set a counter in a cell.
I want it to count up the next time I open the template?

Geir
(e-mail address removed)
 
What you would need to do is write out your counter to a
sheet (hidden if you don't want to see it). Then update
the counter each time the spreadsheet opens.

You could do it something like this
Private Sub Workbook_Open()

worksheets("Sheet1").range("A1").value = worksheets
("Sheet1").range("A1").value + 1

End Sub

Hope this helps.

Kirk
 
Back
Top