View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
damorrison[_2_] damorrison[_2_] is offline
external usenet poster
 
Posts: 38
Default 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.