Replace a Text in 255 character Array Formula

Hi,

I am totally new to vba and I have been googling around to find a solution that would help me find and replace a word (for example, 3 letter month) in array formula that has 255 character but I couldn't find one that could be used or I do not know how to incorporate it into my code. If you can help me with this dilemma that would be great. Thank you!!

This is part of a vba code I am using to replace

Please Login or Register  to view this content.

The code below is the array formula that I want to change using vba code.

Please Login or Register  to view this content.

pls attach sample workbook with sample input and expected output.

Why not incorporate a variable from a cell value or some such

1. Do the cells 'A1', 'C9', 'T2' in the array formula be in the same sheet ('Check') as the area "B7:O44" with array formulas ?
If yes, then the cell 'C9' in the array formula (... "!$B$45:$BK$63) = C$9" ...) itself is located in the area in which there are array formulas.
Is it supposed to be this way ?

2. No loop is needed:

Please Login or Register  to view this content.

3. Some example of a data layout would be helpful

Thank you all for replying back to my post. I tried porucha vevrku's code in post #5 and it worked. It changed all the values I wanted to the desired result. Thank you all so much!!!