Dynamic Named Ranges Viewing in Name Box
You can verify it by using F5 (Go To) and typing in the dynamic range name
and ensuring it references the right range. Or, inside the
Insert/Name/Define, when you click on the name, you'll see the range
highlighted by the border when you then click in the Refers-to box.
"dakotasteve" wrote:
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
|