Anthony's VBA Forum

[tssgw]

I have a spread sheet and when it is opened it will create a new random number (let say in cell d10).

What I want is each time the spread sheet is opened it would get the random number created from cell d10 and then write it to cell "a10" then drop down and write the number to "a11" the next time it is opened.

Basically Keep a history of each random number created when the sheet is opened.

[mohan.ankur]

You would need to write a code on the Workbook Open event.

Something like below...

Private Sub Workbook_Open()
Range("A65536").End(xlUp).Offset(1, 0).Value = Rnd()
End Sub
_________________
http://www.exceldepot.com
http://www.xlmacros.com
http://www.learnexcel.org