Long formulas to breakdown R1C1 style formulas in vba

Hi Experts,

Been trying to figure out this for half a day already.

Please Login or Register  to view this content.

Why when I run the macro, the output came out like below?:-
{=IF($S2="","",IF(AND(W2="Rerouted to Creator",OR("OSB_USR"=INDEX($C$2:$C$39,MATCH(1,($B2=$B$2:$B$39)*(MIN($H2:$H$39)=$H$2:$H$39),0)),$U2=INDEX($F$2:$F$39,MATCH(1,($B2=$B$2:$B$39)*(MIN($H2:$H$39)=$H$2:$H$39),0)))),XXXXX, YYYYY))}

Seems like it doesn't recognize the XXXXX and the YYYYY as strings that needs to be replaced...
I've done this several times for other long formulas and it works, although it could be such a painful thing to do... but I just don't get it why this one doesn't work?

Really appreciate if anyone out there can correct my formulas..

Thanks in advance.
DZ