Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Varible inside of a proper address
Top of the morning
Assume the following: LogSheet being a definied string variable LogSheet has the value of 'Feb' assinged to it It is used in the following line of code ActiveWorkbook.Names.Add Name:="count", RefersToR1C1:="=LogSheet!R8C7" The code runs I want Feb!r8c7.....I get LogSheetr8c7 Thanks in advance for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Varible inside of a proper address
Try this
ActiveWorkbook.Names.Add Name:="count", RefersToR1C1:="=" & LogSheet & "!R8C7" If this does not work you may have to sent the string to a variable first x= "=" & LogSheet & "!R8C7" then ActiveWorkbook.Names.Add Name:="count", RefersToR1C1:= x TerryK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Varible inside of a proper address
Thanks for the solution....worked liked a charm
-----Original Message----- Try this ActiveWorkbook.Names.Add Name:="count", RefersToR1C1:="=" & LogSheet & "!R8C7" If this does not work you may have to sent the string to a variable first x= "=" & LogSheet & "!R8C7" then ActiveWorkbook.Names.Add Name:="count", RefersToR1C1:= x TerryK . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't ADDRESS work nested inside SUMIF? | Excel Discussion (Misc queries) | |||
INDIRECT(ADDRESS) inside a VLOOKUP | Excel Worksheet Functions | |||
varible table not | Excel Worksheet Functions | |||
varible table | Excel Worksheet Functions | |||
Indirect address inside "" | Setting up and Configuration of Excel |