Thanks Bob,
this is a great solution! I appreciate your help!
steve
--
DakotaSteve


"Bob Umlas, Excel MVP" wrote:

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