I generally use a vba function to show me the dynamic named range addresses.

Function rngAddress(rng As Range) As String
rngAddress = Replace(rng.Address(True, True, xlA1, True), _
"[" & ThisWorkbook.Name & "]", "", 1, 1, vbTextCompare)
End Function

Copy into a vba module. Then enter
=rngaddress(YourRangeName)
in a cell somewhere on a worksheet.


"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