Thanks Tom.
I was just wondering how to put entire range values in an memory arrey?
and the how to refer and retrive or manipulate the same from arrey.

I have searched the vba help files but not explained properly.

Thanks,
Ketan