counter in worksheet

K

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
 
Top