Vijay

A #9 subscript out of range error is generated if the code can't find a
referenced element in the code, for example if you reference Sheet10 and you
don't have one

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"vgurusa" wrote in
message ...

Hi JE,

Thats not working, I always get an error subscript out of range error!

Can you suggest another way !

Thanks,

Vijay


--
vgurusa
------------------------------------------------------------------------
vgurusa's Profile:
http://www.excelforum.com/member.php...o&userid=28100
View this thread: http://www.excelforum.com/showthread...hreadid=478321