Copy titles from another workbook
There are several worksheets that I use that have the same
titles. I have created a file at C:\ILA\GuestTitles.xls
that have the titles I want in Sheet1 of that workbook.
How can I copy the titles in GuestTitles.xls to any
current worksheet.
I have this much:
Workbooks.open Filename:="C:\ILA\GuestTitles.xls"
I can't predict the name of the activeworksheet (the
target sheet) and thus am not sure how to copy the titles
over.
GuestTitles has titles from A1:L2.
I hope I have been clear enough for a response.
Thank you.
|