Excel97/2000 Filtering problem

[jobuxton]

I've got a workbook using a procedure to filter data. This works perfectly well for the Excel 2000 users, but produces the error 'AdvancedFilter method of Range Class failed' when run in Excel 97.
Any ideas?

Code below.

Thanks. Jo.

Range("K1:S2000&quot.AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("A3:I4&quot, _
CopyToRange:=Range("A5:I2000&quot, _
Unique:=False

 

[aMember]

I am guessing because your filter range and the copy range are not the same size