A colleague uses Excel 97, and received an error "1004 application-defined or object-defined error" running a workbook that works fine in Excel 2000. Frustratingly, their version of excel doesn't permit me to edit/view the code, and the debug button is greyed out... even when i supplied a password-deprotected version
Anyway, by deduction the code stops at

Selection.Replace What:=y1, Replacement:="", LookAt:=xlWhole,
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=Fals

This sub is defined as

Option Explici
Dim y1 As Varian
Sub code(
Sheets("Sheet2").Selec
y1 = Sheets("Sheet1").Cells(1,1).Valu
Sheets("Malcoded").Columns("A:A").Selec
Selection.Replace What:=y1, Replacement:="", LookAt:=xlWhole,
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=Fals
...

Presumable something to do with how i have defined "y1", or how i hav selected the range to operate on
Any ideas... can't debug this one on their PC and no Excel 97 to test
TI

Mike