pl456
Registered User.
- Local time
- Today, 14:39
- Joined
- Jan 31, 2008
- Messages
- 150
I have a problem with a macro that finds a date and replaces it with nothing leaving an empty cell.
When I record the macro it works fine, however when I run it again on new data it doesnt find the date, even though I can clearly see the date exists.
Another strange thing is if I select the cell an click on the data in the formula bar then run the macro it finds and replaces the date.
Does anbody have any idea how to resolve this?
When I record the macro it works fine, however when I run it again on new data it doesnt find the date, even though I can clearly see the date exists.
Another strange thing is if I select the cell an click on the data in the formula bar then run the macro it finds and replaces the date.
Does anbody have any idea how to resolve this?