View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarkV MarkV is offline
external usenet poster
 
Posts: 37
Default Automatically adding values to cells...

Hi all.

I need some help on this problem;
Hope this make sense; here goes...

Cell D11 has a button with a macro that generates random numbers when clicked.
The generated value is displayed in cell D9 fixed. I want this value
generated to display in cell D12 . When I click the button again the new
value generated must display in D13 and so on. How can I achieve this?

This would be great help...thanks all.