Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I just learning to set up and use dynamic named ranges, unfortunately when I
set them up using the InsertNameDefine method (giving the range a name in the Names in Workbook box type), I noticed that the range name I established doesn't appear in the standard name box immediately to the left of the formula bar. This makes it difficult to confirm the range is correct. Am I right about this fact? Is there any way around this so that I can visually look at my range like I can when I set up a range name the old fashioned way? Thanks everyone! DakotaSteve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Viewing Named Ranges | Excel Discussion (Misc queries) | |||
Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
Problem with Dynamic Named Ranges | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |