Thanks very much for your help. However, although i am no longer gettin
any error messages, the macro is not doing anything to my data!
I am trying to remove any text from a cell, ie
abc123
123abc
ab123c
becomes...
123
123
123
Any further help would be much appreciated (apologies if this is
simple task being made difficult by a simple user!!!
-----------------------------------------------
~~ Message posted from
http://www.ExcelTip.com
~~View and post usenet messages directly from
http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements