| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Sheet by any other name.....
Hi All........
I am opening a second Excel file and copying the only sheet therein back to my original file. All code works fine, except that it requires me to hardcode the SheetName of the second file. I would like to be able to retrieve the sheet regardless of what it might be named. Here's what I'm using now Sheets("BUYER_CB").Select Sheets("BUYER_CB").Copy After:=ThisWorkbook.Sheets(1) TIA for any assistance Vaya con Dios, Chuck, CABGx3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| Export sheet store sheet import sheet. | Excel Programming | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Threaded Mode
