macro to automatically update dates

[Cheryl]

Hi -

I am trying to create a macro that would automatically change dates even
when the date is included with text. (ex: "the 2008 engagement" - to - "the
2009 engagement")

Any help would be greatly appreciated

 

[Gord Dibben]

Turn on the macro recorder whilst you Edit>Replace

2008 with 2009

Note: do NOT use "match entire cell contents" oprion.


Gord Dibben MS Excel MVP