Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi experts in the community,
as VBA newbie I know there are two possibilities to reference a worksheet in an application: Example: ... Worksheets(workSheetID).Range("openIcon").Value ... where workSheetID is either: a.) a numerical ID, the sheet index or b.) a string, the name of the sheet as it is displayed in the sheet tabs. Question: how can I reference the sheet in VBA without being intertwined by either sheet name changes or insertions of new sheets by the user? Thanks for your help Have a nice day Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cleaning up Excel 97-2003 worksheets to work properly in Office 20 | Excel Discussion (Misc queries) | |||
Cleanup worksheets from 97-2003 to work properly on Excel 2007 | Excel Worksheet Functions | |||
Reference different worksheets | Excel Discussion (Misc queries) | |||
3d reference not working properly | Excel Worksheet Functions | |||
Worksheets Don't Properly Send When Emailing | Excel Discussion (Misc queries) |