VBA code to copy and paste data multiple times [Closed]

 Blocked Profile -

is it possible to parse a column and find a value in it, and copy and paste a particular range based on that value in the previous range? the value is the multiplier which tells how many times the range should be pasted.

and i need this to repeat everytime.

1 reply

Yes this is possible.

Here are some code examples that will assist in the inspection of cell values:

theCellValue = ThisWorkbook.Worksheets(WS).Range("A4").value

Then, if the value is being stored in the cell, you would loop by the variable, as in:
for theloop = 1 to theCellValue
MsgBox("The Counter is on " & theloop & " of " & theCellValue)

There you have it!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!