counter in worksheet

[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)

 

[Kirk]

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