Merging two workbooks
 

I'm trying to merge two workbooks.

I select the next available row in my Bookname workbook by:

Range("A2").End(xlDown).Offset(1, 0).Select

Then I open the other workbook, determine the range and say:

Sheets("Sheet1").Range("A1").CurrentRegion.Copy _
Destination:=BookName.ActiveSheet.ActiveCell

But VBA doesn't like my destination. How do I specify the currently selected
cell in my destination workbook? Or, alternatively, the first free row (the
one after xldown)?

--
Thanks,
Fred
Please reply to newsgroup, not e-mail