Thread: Find and Replace (with changing date) in macro

I am trying to automate a report update that requires a find a replace in the middle of the process and need it to use an updated date everyday. I tried to get it to record my copy/paste of the date cell to use in the find&replace...no luck. Also, tried to set the date cell as an active cell...no luck.

It just wants to hard code in the original dates I pasted into the Find&replace window. This is how it currently set up...

Selection.Replace What:="2011-0929", Replacement:="2011-0930", LookAt:= _
        xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Thank you

Hello mattrp and welcome to the forum.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here