From Excel Help, this is the correct way to define a range with start and end points:

Worksheets("Sheet1").Range(Cells(1, 1), Cells(5, 3))

I was actually thinking of using an existing named range defined manually, though.

--
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

"Pentoast" wrote in message ups.com...
That would probably work better, but as I said before, I'm pretty new
at this, so I'm not too sure how to define the range that I need. I
tried this, but it didn't work.

MyVariable=objXL.Cells(1, 1).Cells(1, 10).Value

I'm just not sure what exactly to use. Any code or help will be
greatly appreciated. Thanks!



Sue Mosher [MVP-Outlook] wrote:
What about defining a range that covers all the cells you want to import?