Post the code you are using and note where the error occurs.

I only follow up on my posts for about four days; I saw your response
only by accident. Good practical advice here...
http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"steinmetzw42 via OfficeKB.com" <u17775@uwe
wrote in message
Thanks Jim.

I'm now having an error pop-up while the code is running. The error is:
"There has been an error with the procedu Method 'Worksheets' of object
'_Global' failed" What would give this error? I've never seen one like this
before. Thanks.