Hi shitij,

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

"shitij" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> shitij
> ------------------------------------------------------------------------
> shitij's Profile:
> http://www.excelforum.com/member.php...o&userid=25145
> View this thread: http://www.excelforum.com/showthread...hreadid=386391
>