As I said before, the only range you need is one that covers all the data you want to import. Include the column heading row as well, if the worksheet has one.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"Neil" wrote in message ...
Thanks for the response, which range do I name?
Neil
On Tue, 6 Mar 2007 10:20:52 -0500, "Sue Mosher [MVP-Outlook]"
wrote:
"ranges"? For an import, you need only one named range that covers all the data you want to import.