Thanks Jim, the first option hasn't worked, I have sent you an email
regarding the second one.

"Jim Cone" wrote:

For two options see this post...
http://groups.google.com/group/micro...4a56698c6ad3b2

'--
Jim Cone
Portland, Oregon USA



"rwmitchell32"

wrote in message
Is there a way for me to delete all custom cell styles in a workbook, without
having to right-click on each one and delete it individually? When I paste
in data which has been exported from other programs (particularly SAP) I seem
to end up with hundreds of different cell styles which are unnecessary and
annoying for me to scroll through to get down to the automatic cell styles
which I generally use.
Any suggestions gratefully received.