Hi Shrinivas,
Mr. Powell has rightly said, please debug the same way.
And If it helps please also check, if you have larger amount of
columns or rows than your friend, since this also cause "Subscript Out
of Range". Run on lesser or same amount of rows , also ensure correct
sheet/file names in th
Shrinivas --
My guess is that the Excel sheet you are trying to reference is either
misnamed or does not exist
When the error appears, click the Debug button -- this will take you
to the offending line of code in the VB Editor
This will enable you do identify the cause of the error
Hope it he