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

Report
-
 Blocked Profile -
Hello,

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:

WS="Sheet1"
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)
next


There you have it!