Depend what you are doing and what you mean by "read", but here's one way:

Dim Vals As Variant
Vals = Range(Cells(1, 1), Cells(1, 89)).Value
'Note you get a 2-D array even for one row
Debug.Print Vals(1, 29)

Maybe look at Transpose also.

Also, if you must post to more than one NG, cross-post, not multi-post. If
this means nothing to you, read:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

NickHK

"shantanu" wrote in message
ups.com...
hi
I am trying to read the values from a excel row. There are 89
columns for each row and same number of data in each rows.
Kindly help

regards
shantanu