Replicate a macro program

  • Thread starter Thread starter Yiu Choi Fan
  • Start date Start date
Y

Yiu Choi Fan

Hi all,

My situation is that I have to do a simulation job with thousands of
replications. I have already had a macro program called "solve" which
records the procedures, this will give me six values in cells from A1 to F1.
However, I need to run this "solve" 1000 times, so that it can output the
values from A2 to F2, A3 to F3 ... A1000 to F1000. Is it possible to do
this?

Thanks very much for your help!!

C.F. Yiu
 
Hi
possible of course :-)
But you may post the relevant part of your code there you
calculate the values and insert them into the spreadsheet.
This way it's easier to append the additional code
 
You must log in or register to reply here.

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

Similar Threads

How to define a Range with variant? 6
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Calculate average in intervals 1
how to add error bars into bar chart 1
BUG in excel iteration system? Very simple illustrative example: can you replicate? 3
Excel Macro to Compare two Columns and write to a third 1
Excel does not execute a button's code when another macro simulates mouse movements & clicks 2
Handle a value from a Range instead of value of a Cell 8

Back
Top