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

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

When I have multiple worksheets open, lets say (3) and they are arranged
horizontaly so you can see all 3, how does VB move between each worksheet and
how does it relate to the sheets position? If I cannot use a name or date to
differentiate between them what is their order? and does it matter if the
macro is local to one of the sheets or can it be in the "personal"sheet?

"Martin Fishlock" wrote:

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