find and replace

[Annette]

How can I programmically find and replace:

mm/yy with (any two digit with / in the middle and two digit)
'mm/yy .... (any two digit with / in the middle with two digits)

This is the answer and will work for the question I asked earlier but I
don't know how to do this in the macro, but it will resolve the mainframe to
Excel problem with the date coming over into excel and treating itself to a
new year!

Thanks!

 

[Tom Ogilvy]

Find and Replace won't work that way, either programmatically or with a
macro.

 

[Annette]

Well ... shoot ... if this won't work .. then how would I look through to
change mm/yy to add in mm/01/yy?

 

[Tom Ogilvy]

By looping through you data and looking at it.