formula

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Is there a way to add a formula that has a perpetual
number in the formula, so that every time the excel file
is opened, it generates a new number in sequence.
 
Use the Workbook_Open event:
right-click the Excel LOGO near the file menu, select View Code, then enter
this:
Private Sub Workbook_Open()
Sheets(1).Range("C3").Value = Sheets(1).Range("C3").Value + 1
End Sub
========change C3 to the appropriate cell.
 
Back
Top