(Solved) – Text Replace in Regular Expression In VBA Excel

(solved)-–-text-replace-in-regular-expression-in-vba-excel

There is a formula:

SUM(GETPIVOTDATA("Water",'Pivot'!$A$3,"cCode",A2),GETPIVOTDATA("Water",'Pivot'!$A$3,"cCode",A2))

and the content of the formula doesn’t matter. I would like to replace all instances of GETPIVOTDATA("Water") with GETPIVOTDATA("Soft-Drink") using regular expression.

Leave a Reply

Your email address will not be published. Required fields are marked *