Hi

I have a macro that makes a copy of particular sheet in the file,
renames it and performs some calculations. The macro contains a loop
and thus it should continue to do this until the loop is completed.
The problem is that the macro stops in between (abruptly) with a run
time error (Copy Method of Worksheet class failed) and on debugging it
highlights the 'copy sheet code' in VBA. Once I close the VBA screen
and try to make copy of the particular sheet manually (using Mouse and
the ctrl key), excel fails to make a copy. I do not understand why this
happens. I than close this file and on reopening the macro works fine
until it encounter this error again.

Do you have any idea why this is happening

Thanks
Karthik Bhat