Need macro to add "N" in the start of all cubevalue excel formulas and ")" in the end

[maheshrk81]

Hi Team,

I need macro to add "N" in the start of all cubevalue excel formulas and ")" in the end. This is my current formula =IFERROR(CUBEVALUE("ThisWorkbookDataModel",G$1,G$2,$C12,$D12),0) and its returning only blank instead of "0", hence its not adding to the Sum formula. Is there a way or macro to add "N" in the start of the formula and ")" in the end.

Thanks & Regards,
Mahi

 

[maheshrk81]

I am able to fix the issue with a Macro. Thank you everyone for checking and help.