VBA Question on Sum Formula

[markallen71]

Hello,

When I add columns in my sheet using VBA

Say A B C D E F G H I J K L M N O P

In Column P I want to sum G19, J19 and M19

=IF(OR(ISNUMBER(G19), ISNUMBER(J19), ISNUMBER(M19)),SUM(G19,J19,M19),"")

Now when I press my button to enable my VBA macro to run and add a new column by copying G19 and Inserting it into G19 and moving the existing G9 to the right to J19 and the rest move to the right as well.

My sum does not advance like if I had it in a range.

I need the new code to be

=IF(OR(ISNUMBER(G19), ISNUMBER(J19), ISNUMBER(M19), ISNUMBER(P19),SUM(G19,J19,M19,P19),"")

can anyone help with this? VBA or formula that can accomplish this?

Thank you,
Mark

 

[markallen71]

Any help on this would be greatly appreciated