Menu
Ask a question Report

Copy a range of Data in Column with a loop

- - Latest reply:  ChrisZ - Mar 13, 2019 at 09:18 AM
Excel Ask a question Report
Dear all,
May I ask your help for a macro which allowed me to copy a range (column) 16350 times :-)
On D5 to D369 I have a formula which do a random calculation.
On F4 to XEA4 I have a number from 1 to 16,350
I need a macro which copy the range D5 to D369 on range F5 to F369 (F4=1);G5 to G369 (F5=2) and so on till XEA5 which is the 16,350 columns...
I need the macro ended when it reach the number 16,350 or XEA4
thank you very much for your help
I hope I was clear as a beginner in VBA
thank you
CZ
See more 

1 reply

Report Respond to ac3mark
Posts
12856
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
August 19, 2019
 1269
0
Thank you
Is this homework? Why a random number?
Report Respond to ChrisZ
-
Hi, the goal is to simulate a lot of different scenario by using the Random formula. Thank you
Respond to ac3mark
Reply Ask a question