macro to automatically update dates

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

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
 
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
 
Back
Top