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..