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
|