Re: Dynamic Named Ranges Viewing in Name Box

You are correct. Being dynamic means that it won't necessarily be the same
range at all times, so Excel doesn't store the details of the range.

You could view it by typing

=myRange

in the formula bar, and the range will be highlighted.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dakotasteve" <dakotasteve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E506E25-A485-4798-AECD-82E14675E1ED@xxxxxxxxxxxxxxxx
I just learning to set up and use dynamic named ranges, unfortunately when
I
set them up using the Insert>Name>Define 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


.