How to change text globally in multiple text boxes

[AntBlabby8]

I inherited a really wonderful model, except ... to the side, there is a rectangle for comments. At the top of the rectangle it says: Variance Comments, Apr Fcst vs. Mar Fcst.

There are more than 60 worksheets with this comment area. I need to change it to Jul Fcst vs. Jun Fcst. When I try a find-replace, it doesn't work. (I had to try it, you know?)

Any ideas how to change them all at one time or otherwise quicky?

Thanks!

 

[Micron]

Loop through the sheets in code and change Apr to Jul and Mar to Jun or reduce the chances of making unwanted changes by expanding the find values; perhaps to the point of finding the entire string. IIRC the vba Find function is not the same as the sheet Find function so don't copy the latter and use that in your code.