Hi

Try copying the code exactly as posted and placing it between your Sub,
End Sub sections.
I have just tried it again and it works fine for me on both XL2000 and
XL2003.

--
Regards

Roger Govier


"OniLink" wrote
in message ...

Hi,

Thanks for your assitance. I am currently using Excel 2000, but I
believe I originally used Excel 2002 to make this. I tried removing
the
line you specified, but it still generates an error. it now outputs:

Run-time error '1004':

Sort method of Range class failed


--
OniLink
------------------------------------------------------------------------
OniLink's Profile:
http://www.excelforum.com/member.php...o&userid=19935
View this thread:
http://www.excelforum.com/showthread...hreadid=518560