View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Macro to paste a copied range

Check out this page Ted
http://www.rondebruin.nl/copy1.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Ted" wrote in message ...
I want my macro to place and paste (^V) a copied range (in
this case just one line) to the first empty row below the
last filled row.

e.g. a10 filled row
a11 filled row
a12 filled row
a13 empty (this is where I want it to appear).

Thank you in advance.

Ted