I am range on Sheet 3 that I copy and then try to paste on sheet 1 that is offset based on a counter. What should the code look like? I have tried to figure it out but I have hit a wall.
Range("a5:F7").Select Selection.Cut Worksheets("sheet1").Activate variable=Range("a5:A7").Offset(counter2 + 3, 0) variable.paste
I know it is copying but I get a debug error when it copies.
Bookmarks