Extending named data range

[grmusselwhite]

Hi,
A very simple question I believe:
I have a named range of cells and want to add to that range.

I cannot just select more cells in the list and re-type in the name box. How do I do it?

Thanks
G

 

[Andrew Poulsom]

You have to use Insert|Name|Define and change what's in the Refers to box.

 

[grmusselwhite]

Thanks