Unique Number

T

Thomas Cox

I am creating an Invoice template in which I need it to generate a unique
random number each time the spreadsheet is opened. Anyone have any ideas
that I could try? Thanks
Tom
 
R

Roman

You can use this macro:

sub auto_open ()
thisworkbook.sheets("sheet1").range("b2").value = _
thisworkbook.sheets("sheet1").range("b2").value +1
end sub

R.
 
Top