Frank Kabel Wrote:
Hi
the formula in column A probably causes this error. Try the following
before sorting:
- select column A and copy this column
- goto 'Edit - Paste Special' and choose 'Values' to remove the
formulas

Now try sorting again


--
Regards
Frank Kabel
Frankfurt, Germany


True that will work, but it will also totally destroy whatever that
formula was meant to do, and judging by this gentlemans Excel novice
status, I'm not 100% sure that you should encourage him to do that
unless he realises the consequences.


--
CFD


------------------------------------------------------------------------
CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306
View this thread: http://www.excelforum.com/showthread...hreadid=237341