Paste method fails in VBA
Hi LaLu,
I tried to use your macr and ended up with an undefined variable, I
supose you are trying to get your next cell placement before you paste
again.
Here;s a simple macro for copy&paste:
Range("A9:FY17").copy Destination:=ActiveCell
Now if you get your loop right for your cell placement you can use the
above code before your next loop.
When you record a macro for your cell placement record it as relative
instead of absolute then your cell selection will go down the proper
number of rows you require.
|