Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
generate different number
hi,
is there a way that excel would generate a different number ( incremented by one) each time a workbook is opened? thanks paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
generate different number
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 "Paul" wrote: hi, is there a way that excel would generate a different number ( incremented by one) each time a workbook is opened? thanks paul |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
generate different number
Paul,
Have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Mike "Paul" wrote: hi, is there a way that excel would generate a different number ( incremented by one) each time a workbook is opened? thanks paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Serial number generate | Excel Worksheet Functions | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
Generate number NOT using a form | New Users to Excel | |||
how can text be set up to generate a number? | New Users to Excel | |||
generate serial number | Excel Worksheet Functions |