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
|