200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I need to copy multiple cells and paste it into another sheet using VBA
So I need to copy a cell put it in another cell then go back to the other column go down a row and paste it into that same cell as before.
I need to do it in a loop because once it is pasted into the other cell it refreshes into a URL and changes an output table.
I know how to get the URL changed and refreshed just can't figure out how to copy with an offset.
Hi Macemmie and welcome to the Forum
If you always want to copy to cell G4 (within the same sheet) then use this (commented) code and the attached file - click button "Loop":
Sub CopyToCell()
' get last row in column B
LastB = Range("B" & Rows.Count).End(xlUp).Row
'Loop through rows in B and copy to G4
For n = 4 To LastB
Cells(4, "G").Value = Cells(n, "B").Value
Next n
' delete this
MsgBox "G4 changed " & n - 4 & " times"
End SubHope this helps.