sequential number

[Mike W]

Hi all,

I feel I should apologise in advance as I've seen this question answered
previously but can't find it now. I want to have a sheet of a workbook
display a new sequential number on opening. That's it really.

any help would be appreciated.

Mike

 

[Paul B]

Mike, you culd put something like this in the workbook open event,

Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1

You may also want to have a look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/sequentialnums.html

 

[Mike W]

Thanks Paul, the code and mcgimpsey link was very helpful.

Mike

 

[Paul B]

Mike, your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003