Naming Ranges

S

Stacy

I received an error while importing to Outlook. It said that my spreadsheet
has no name ranges and to use Excel to name the range of data. I tried using
help and am now thouroughly confused. Do I have to name each column? I
tried and it did not work. I tried creating a name with the name box at nuxt
the the forumla bar.

Thanks!

Stacy
 
G

Gord Dibben

Select the range of data in all columns at once then Insert>Name>Define.

Type a name like MyRange and OK

Save then do the Import from Outlook.

Alternative with no named range.........................

If your worksheet with the data is first sheet in the workbook, Outlook should
use that and not bother you with the "named range" message.


Gord Dibben MS Excel MVP
 
Top