Automatically adding values to cells...

  • Thread starter Thread starter Markv
  • Start date Start date
M

Markv

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.
 
Posting the macro would help but this will always write to the first empty
cell (reading up) in column D

Cells(Rows.Count, "D").End(xlUp)(2).Value = x

Mike
 
thanks but can you clarify your answer in more detail. can I add this line
into a new module?
 
Hi,

On it's own it will do nothing. You have a button that generates a random
number and writes it ti D9 and it's that macro that needs changing. Post the
macro and someone will help.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top