macro to automatically update dates
 

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


--
- Cheryl

macro to automatically update dates
 

Turn on the macro recorder whilst you EditReplace

2008 with 2009

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


Gord Dibben MS Excel MVP

On Thu, 14 Aug 2008 13:36:00 -0700, Cheryl
wrote:

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