You're welcome - thanks for feeding back.

Pete

On Sep 4, 1:48*pm, Milind Keer
wrote:
Thanks again pete!! *I will certainly try to implement your suggestion.

Well!! we get this huge data file on monthly basis and currently record
contains 55000 rows which may increase in future. Hence on the safer side i
kept no. of rows 65000 which is the upper limit of XL.

I guess accurate upper limit is 65536 rows but for an array u can use 65535.