Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Sheets
I'm trying to utilize sharing my workbook for the first
time, and have been getting "Run Time Error 1004 Application-defined or Object Defined error" It appears that the problem is arising because my macros reference locally defined sheet names. For example: wsSheet.Visible = wsSheet.Name = "Prices" There is probably a simple answer to this question, but how do I qualify the locally defined name with it's actual worksheet name. For example, the "Prices" sheet above is actually Sheet11. How do I change my code to reflect this? Thanks all! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Sheets
Are you asking how you use the codename of the sheet vice the tab name?
? worksheets("Prices").codename Sheet11 You need to know one or the other. ? sheet11.Name Prices It would be difficult to use the codename as a variable reference. -- Regards, Tom Ogilvy "Eric" wrote in message ... I'm trying to utilize sharing my workbook for the first time, and have been getting "Run Time Error 1004 Application-defined or Object Defined error" It appears that the problem is arising because my macros reference locally defined sheet names. For example: wsSheet.Visible = wsSheet.Name = "Prices" There is probably a simple answer to this question, but how do I qualify the locally defined name with it's actual worksheet name. For example, the "Prices" sheet above is actually Sheet11. How do I change my code to reflect this? Thanks all! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing sheets | Excel Discussion (Misc queries) | |||
When referencing other Sheets | Excel Discussion (Misc queries) | |||
Referencing a Range of Sheets | Excel Discussion (Misc queries) | |||
Referencing Different Sheets in VBA | Excel Discussion (Misc queries) | |||
Referencing other sheets - updates | Excel Discussion (Misc queries) |