MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unique Number

Posted by Wayne Maloret on January 18, 2002 2:59 AM

Can anyone help me ??

I am creating a Purchase Requisition Form in Excel and i would like each time that the document is opened that it be automatically given a unique number (serial Number)

Is this possible ?


Posted by Lewis (1) on January 18, 2002 3:19 AM


I have a similar thing with Problem Reports. I have a macro that tranfers data from the form to another sheet. It contains the following

Sheets("New Problem").Select

ActiveCell.Value = ActiveCell.Value + 1

which increases the value in cell B5 by one every time the macro is run.