| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using worksheet code name in this code
I'm trying to use a worksheet code name in this code
"=VLOOKUP(RC3,Sheet1!NamedRange,2,FALSE)&""-""&'Sheet2'!RC4" I have a code name for Sheet2 that I want to add to this. Can someone assist us? We are so far having no success. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using worksheet code name in this code
As a guess...
"=VLOOKUP(RC3,Sheet1!NamedRange,2,FALSE)&""-""&'" & Sheet2.Name & "'!RC4" -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: I'm trying to use a worksheet code name in this code "=VLOOKUP(RC3,Sheet1!NamedRange,2,FALSE)&""-""&'Sheet2'!RC4" I have a code name for Sheet2 that I want to add to this. Can someone assist us? We are so far having no success. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Code Conflicts With Worksheet Change Code | Excel Programming | |||
| Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming | |||
| Altering code to reference the worksheet before the active worksheet | Excel Programming | |||
| Return to previous worksheet after code pastes in another worksheet? | Excel Programming | |||
Linear Mode
