sequential number
 

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

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

"Mike W" wrote in message
...
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

Take a look he

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

In article ,
"Mike W" wrote:

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

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

Mike

"Paul B" wrote in message
...
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

"Mike W" wrote in message
...
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

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

"Mike W" wrote in message
...
Thanks Paul, the code and mcgimpsey link was very helpful.

Mike

"Paul B" wrote in message
...
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

"Mike W" wrote in message
...
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