Sharqua wrote

Did you mean for this to be all of the columns from B to
G in Row 42?

No. I only wanted to look at two cells (B42 and G42)... however:

Range("B42,G42").Cells.Replace What:=OldMonth, Replacement:=NewMonth,

Doh! Discovered I was referencing the wrong row! Changed to 41 and all is
well :) Forgot I had recently deleted a row after macro was written.

Thanks for jumping in, though.

--
David