View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dakotasteve dakotasteve is offline
external usenet poster
 
Posts: 10
Default Dynamic Named Ranges Viewing in Name Box

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