ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   What does it mean define ranges in Excell for import (https://www.excelbanter.com/new-users-excel/108916-what-does-mean-define-ranges-excell-import.html)

Ron

What does it mean define ranges in Excell for import
 
I am trying to use an Excell database of names to be used in Outlook and it
asks for defining of ranges . Its a one column. I dont understand. Please
help

Ron Coderre

What does it mean define ranges in Excell for import
 
I believe MS Outlook is expecting a "named range".

See Debra Dalgleish's instructions on how to create one:
http://www.contextures.com/xlNames01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron" wrote:

I am trying to use an Excell database of names to be used in Outlook and it
asks for defining of ranges . Its a one column. I dont understand. Please
help


Gord Dibben

What does it mean define ranges in Excell for import
 
Ron

One column with just names?

Select and InsertNameDefineAdd.

Give the range a name like MyRange and OK your way out.

If the one column is more than a list of names you may have to re-arrange.

i.e.

Name
Address
email address

would have to go into separate columns with headers

Name Address Email Address


Gord Dibben MS Excel MVP

On Thu, 7 Sep 2006 09:09:03 -0700, Ron wrote:

I am trying to use an Excell database of names to be used in Outlook and it
asks for defining of ranges . Its a one column. I dont understand. Please
help




All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com