Hi,

Try this

sub copyselectiontowindow2
Selection.EntireRow.Copy
Windows(2).ActiveCell.EntireRow.PasteSpecial xlPasteAll
end sub
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Hawkdriver" wrote:

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