Numerical sequence

  • Thread starter Thread starter Kassie Alcorn
  • Start date Start date
K

Kassie Alcorn

I was wondering if it was possible to have a numerical sequence (i.e. as a
quote number) so as every time a document is opened a new quote number is
issued automatically within a cell?

In regards to three queries I have made, all concern Microsoft Excel 2002.

Thankyou in advance.
 
Hi
only possible with VBA. You may try for example the following code (put
this in your workbook module):
sub workbook_open()
with me.worksheets("sheet1").range("A1")
.value=.value+1
end with
end sub
 
Thankyou Frank.

Pardon my ignorance but what is VBA?

So to try this code I put '.value=.value+1' in the cell I wish to have this
tool?

Thanks
 
Back
Top