Dynamic Named Ranges

[TOPH]

I have been trying to set up a dynamic named range using a tip found elsewhere on this forum.
Problem is I can see the range name when I go Insert/Name/Define but when I click on the name box at the top left of the excel screen its not there.

The list is currently about 140 rows by 9 columns and the top left of the list is B11

The formula I put in the 'Refers to' box is =OFFSET(ORGS!$B$11,0,0,COUNTA(ORGS!$B:$B),9).

Once I've sorted this out I'll be adding new entries using a macro which will insert the new row and resort it. Then if the dynamic range works it will automatically expand to capture all the names in the list

I'm running Excel 2000.

 

[xenou]

You will not see them names in the name box at the top left. However, don't doubt that it is there and available for use -- except that you won't be able to use the name box to "select" it as with other names.

ξ

 

[TOPH]

Xenou

Thanks for a fast reply - I was hoping that would be the answer but I haven't had time to try it out today.

 

[SamTYler]

In the formula box, set the cursor where you want the Name, then, use Excel Menu:Insert; Name; Paste