Insert Randon Number in Next Cell Down Macro

There may be an easier way to do this but this is what im wanting and how I did it.

I've recorded a macro to insert a random number between 0.50 and 0.70 into cell A1. I've used a macro because I don't want the formula visible when I click on cell A1 and because I don't want it to change every time I open up the spreadsheet. I would like my macro to do the exact same thing in the next cell down the next time I press the button and so on and so on.

This is how ive done it. I start macro record, click data tab, click data analysis, click Random Number Generation and OK, this then brings up the box where I get it to insert my requested random number in my selected cell, I then format this cell to 2 decimal places, I then stop recording macro. (see below)

Please Login or Register  to view this content.

Any help would be appreciated, Im a novice to macros so easy instructions please!

Hi, this should work:

Please Login or Register  to view this content.

Hope it helps!