Hi
I'm trying to generate a random integer between (2,12) - like the roll of two dice.
I need a way to stop the Randbetween formula from refreshing when I am entering data into non related cells.
I found this vba function that proclaims to do it but I can't get it to work.
Then entering into a cell:Please Login or Register to view this content.
Please Login or Register to view this content.
Any idea what I'm doing wrong? Or does anybody have an alternate way of doing this?
Thanks
Bookmarks