View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hawkdriver Hawkdriver is offline
external usenet poster
 
Posts: 7
Default Macro help with copy and insert

I am trying to copy a range of rows from one workbook and insert into
another. I have two windows arranged horizontaly and am activating
workbook(2), selecting the range of rows that i want then selecting the row
in workbook(1) that i want to insert the copied rows above. The rows are not
the same range in diff. workbooks and the workbooks have different names. Is
there a way to select the "active rows" like i can with active cells?

Jason