HI!
Trying to replace this:

"Current + 4 Shortages" with "January Shortages"

Code: Cells.Replace what:="Cur+4 Shortage", Replacement:=MonthName(4 + Month(Now())) & " Shortage

The syntax was working last month, but It's not working on this month. Weird..