Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I export several sheets from Access to an Excel workbook and run a macro that
formats each of the sheets (bolds and centers titles, sets column widths, etc.). When the macro is done, it leaves the focus on the last sheet of the workbook. I want the focus to be on the first sheet. All of the sheets have names (not just Sheet1, Sheet2), but I don't want to hard-code the sheet name because it could change. Sheets("Sheet1").Select does not work. Is there a generic way to refer to Sheet1 (that has been renamed)? Thank you, Judy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
Select sheet with VB code | Excel Discussion (Misc queries) | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Select Sheet then Select Range | Excel Programming |