View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SteveT SteveT is offline
external usenet poster
 
Posts: 57
Default Select Variable Range paste last row + 1

Hello,

Looking for macro solution to perform following

1) Copy Variable Range (A2:C?) from source.xls
2) Paste Range to last row + 1 destination.xls

There are many posts concerning but none are performing task needed.
Ron de Bruin's solution in posting "copy & paste macro" has come closest but
I continually get compile error.

Thanks in advance for any assistance.

BR,

Steven