Hmm, it shouldn't make any difference, but perhaps 97 is more literal and requires a sheet to be specified in conjunction with a range.

Try the attached, I know it works ok on mine (2000), I have just included "ActiveSheet" and some data

John