Hi,
you will get that error if the worksheet is protected.
If this is the case then your code has to unprotect the sheet at the
start, then reapply protection at the end.

Ken Johnson