generate different number

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

hi,
is there a way that excel would generate a different number ( incremented by
one) each time a workbook is opened?
thanks
paul
 
Yes but only by using VBA...The following will increment the value in cell L1
on Sheet1 by one every time the workbook is open.

Private Sub Workbook_Open()
Sheets("Sheet1").Range("L1").Select
ActiveCell.Value = ActiveCell.Value + 1

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL time match 3
random number generator 6
Find occurance of a part number? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Form to open when workbook is opened 2
Formula needed for repetative spreadsheet 3
Sum of different value in different worksheet & cell number 2
Help Please! Random generator issue. 2

Back
Top