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" <[email protected]> wrote in message
news:[email protected]...
> 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 here:

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

In article <[email protected]>,
"Mike W" <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> Thanks Paul, the code and mcgimpsey link was very helpful.
>
> Mike
>
> "Paul B" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> > >
> >
> >
>
>