VBA code to copy and paste data multiple times
Closed
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.
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.
Related:
- How to copy and paste multiple times in excel vba
- Number to words in excel formula without vba - Guide
- Discord invisible name copy and paste ✓ - Internet & Social Networks Forum
- Vba case like - Guide
- How to lasso multiple objects in photoshop - Guide
- How to take screenshot in excel - Guide
1 response
Yes this is possible.
Here are some code examples that will assist in the inspection of cell values:
Then, if the value is being stored in the cell, you would loop by the variable, as in:
There you have it!
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!