VBA code to copy and paste data multiple times

lakshminair - Sep 19, 2018 at 11:05 AM
 Blocked Profile - Sep 19, 2018 at 04:11 PM

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 response

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!