It would be really helpful if you'd include the relevant information from previous messages. Unless you do, those of us using offline readers have to go back and retrieve the earlier part of the thread, which will delay any response.

Your statement

MyVariable=objXL.Columns("a").Value

does not return an array. This one does:

MyVariable=objXL.Columns("a")

However, it's an array generated from all 65536 cells in the column, probably not what you're looking for. You might want to use a named range or specify a range of specific cells you want to use.

Also, there are newsgroups specifically for Excel issues if you need more assistance on using things like Columns and Range.
--
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 oups.com...
oh... I'm sorry, I must have renamed it somewhere along the way just so
I could identify it better. It's actually in the code in the first
post. It is named "myVariable" in that code. Thanks!