Unique Number

[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

 

[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.