Hi,

The error was encountered on the following line...

With .Worksheets(i).UsedRange

no the sheets were not protected..

Cheers
Sidd