Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using sheet codename problems
I'm having problems with the way I access sheets of the
ActiveWorkbook from an addin. Basically, I need to rewrite the following line of code (simplified for this example) to use the sheet's codename (SamplePrep) instead of the sheet's position in the Sheets collection (sheets (1)): vResult = ActiveWorkbook.Sheets(1).Range("A:A").Find (iSearchValue).Offset(0,2).Value to something like this: vResult = ActiveWorkbook.SamplePrep.Range("A:A").Find (iSearchValue).Offset(0,2).Value Any ideas or suggestions would be *greatly* appreciated. Thanks in advance, Dustin Carter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using sheet codename problems
Dustin,
The codename should not be qualified: vResult = SamplePrep.Range("A:A").Find -- John Green - Excel MVP Sydney Australia "Dustin Carter" wrote in message ... I'm having problems with the way I access sheets of the ActiveWorkbook from an addin. Basically, I need to rewrite the following line of code (simplified for this example) to use the sheet's codename (SamplePrep) instead of the sheet's position in the Sheets collection (sheets (1)): vResult = ActiveWorkbook.Sheets(1).Range("A:A").Find (iSearchValue).Offset(0,2).Value to something like this: vResult = ActiveWorkbook.SamplePrep.Range("A:A").Find (iSearchValue).Offset(0,2).Value Any ideas or suggestions would be *greatly* appreciated. Thanks in advance, Dustin Carter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
string to codename | Excel Discussion (Misc queries) | |||
Referencing worksheet CODENAME in a chart object. | Excel Discussion (Misc queries) | |||
Worksheet codename | Excel Programming | |||
How do I determine the Acrobat Distiller codename? | Excel Programming | |||
Codename equivalent for Series | Excel Programming |