I am trying to figure out how to build a macro to use Find and Replace to look for specific text and replace that text with tomorrow's date.

Look for: datez
replacement: yyyymmdd
which needs to be tomorrow's date.

Any help would be appreciated.

Thanks
tchase01