| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically update macro | Excel Worksheet Functions | |||
| Automatically update graphs | Charts and Charting in Excel | |||
| Automatically update cells | Excel Discussion (Misc queries) | |||
| Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
| Dates that automatically update ... | Excel Discussion (Misc queries) | |||
Linear Mode
