Often there is more detail with the error number 1004 - could we have
that please?

It's very likely a compatibility  problem and the first thing I would
investigate (on an Excel97 machine) is removing the dot in the sheet
name and the code. The next thing would be to simplify the range to
say Worksheets("C.Gibbs").Range("c8:h14") and see if the code still
trips up.

ClearContents does exist in XL97 by the way.