| 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 |
| 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 | |||
Threaded Mode
