Is there another way to remove formula from a worksheet keeping the values using macros, I've tried using:

Sheets("NATIONALS").Select
Range("A804:G827").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False


It works every other time I use it, but in this case I get a Dr Watson errors. Is there another way of doing this.

Excel 97.