Hi ****ij,

Do you really mean "cells of whole excel file" or maybe the cells of the
whole used range on a sheet of that file? If it is the latter then it is as
easy as the following:

Dim Arr as Variant
arr=ActiveSheet.UsedRange.Value

Regards,
KL

"****ij" wrote in
message ...

Thanks for the appropriate reply. That does really helped me. In
continuation to above reply, can you advise me the way to have cells of
whole excel file in an array in a single shot instead of reading it in a
loof of reading cells individually. Your words of little help can work
wonders for me.
Once again, thanks for the suitable reply.


--
****ij
------------------------------------------------------------------------
****ij's Profile:
http://www.excelforum.com/member.php...o&userid=25145
View this thread: http://www.excelforum.com/showthread...hreadid=386391