Issue with FIND/REPLACE Excel 2003 VBA

Hi All,

I have a report with lots of time data, format [hh]:mm:ss using Excel 2010 at home but use 2003 at work.

I would like to replace 00:00:00 with "" (blank), so used the macro recorder and performed the steps manually which worked fine.

The problem is I have tried to make it generic, and it seems to run the macro but does not replace the values. I was wondering if someone could spot something I'm missing. I can mock up a demo sheet as the original contains confidential data, but was hoping it was a code/logic error. The code is below:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Thank you

Pete Austin

I think you're spot on with the first part - in which case why does manually using find/replace work and how can I tell vba to look for the time value?

Thanks very much

Pete Austin