Data Cleaner Macro: Dates, Zeros, and TRIM

Hello Excel Masters

I need some help with a data cleaning macro that will eliminate default dates "1/0/1900" and cells that contain only a zero "0". I also want to utilize the TRIM function to eliminate extra spaces.

I humbly submit my neophyte code in the hopes someone can help. When I run this macro I receive the error "Run-time error '13': Type mismatch". When I press the Debug button, the yellow highlighter goes to the line of code that reads: cell.value = Trim(cell.Value)

Much Thanks for the Help!!!

Please Login or Register  to view this content.

Hi Leith, Thank you so much for the reply

I gave it a shot, but it still me the same error and again highlights:

Please Login or Register  to view this content.

Could it be that I have caused some confusion with my code by declaring a range named 'cell'? It is 'cello' now because I was experimenting with possible solutions.

Right On Leith, that did the trick

I used '.Text' in other parts of the code and should have followed suit with that part of code. I know your addition of the IF statement played a huge part in getting things to work correctly as well.

Thanks Again for the valuable help!!! "West Coast Love"