| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change multiple Chart Titles in different sheets in the same Workbook | Excel Worksheet Functions | |||
| Adding titles to formatted gridded workbook | Excel Discussion (Misc queries) | |||
| Copy Titles in a long list of rows | Excel Discussion (Misc queries) | |||
| HOW DO I PRINT A LIST OF WORKSHEET TITLES FOR A SPECIFIC WORKBOOK | Excel Discussion (Misc queries) | |||
| How do I loop through workbook and rename all chart titles? | Excel Programming | |||
Threaded Mode
