By headers I mean you have at least 2 columns with titles like Name Address
and the data in rows below these.

Select the title cells and those below with the data.

Assume A1:B4 looks like this.............

Name Address
Gord 123 main st.
Toby 456 second sr.
Bert 789 third st.

Select A1:B4 and InsertNameDefine.

BTW........nothing is done in the fx box........fx is the Function Wizard


Gord

On Wed, 21 Nov 2007 15:13:01 -0800, Toby wrote:

when I select the row with the headings on it....do I rename in the fx box?

"Gord Dibben" wrote:

Yes.

Select the range that has the names and addresses including headers and
InsertName?Define.

Give it a name like MyName

Save then try again.


Gord Dibben MS Excel MVP

On Wed, 21 Nov 2007 14:21:00 -0800, Toby wrote:

I am trying into import from outlook a data base that is in Excel...error
pops up stating that there is "no named ranges" any ideas or suggestions?