Why isn't my name box working?

[kwp004]

Why isn't my name box working?

For example, I highlight A1:B2, the name box briefly displays "2R X 2C", but as soon as I click on the name box to define the range, it defaults back to A1.

If I've created a list of named ranges, when I click the drop down menu of the name box, it displays the names briefly, but then immediately defaults back to A1.

 

[Perpa]

Why isn't my name box working?
QUOTE]

kwp004,
You have to use the Name Manager in the Formulas tab to define each block of cells.

Select 'Formulas>Define Name', then enter the name after 'Name:', then 'Refers to:' should default to 'Sheet1!A1'

Add a ':' and it should repeat the 'A1', then change the second 'A1' to 'B2'…it will look like this => Sheet1!A1:B2

The defined name will default to 'Workbook' which will allow that block of cells to be called from any sheet. You can change that to 'Sheet1' or 'Sheet2' or whatever, if you only need the defined name for a single sheet and not the entire workbook.

Now when you select that name from the name box it will select the appropriate block of cells.

You can clear the grid and wrap the text in each block if desired as follows:
Select the name from the name box, then select 'Home> Merge and Center'
Then while the cells are still selected, select 'Wrap Text'

To put a box around each block of cells…Select the name from the name box, then select 'Border' and then select the border you want.
Repeat for each block of cells.
Hope this is helpful.
Perpa

 

[RoryA]

Do you have any add-ins like Dropbox loaded?

 

[My Aswer Is This]

I'm able to define a range by doing this:

1.Select The Range

2. Then click in the name Box and Type in the name you want to give the range.

I never go into the Name Manager to do this

Works for me.