Auto-update column formula
 

I have a simple formula as follows
A B C
1 100 200
2
3 4 5 (4*100)+(5*200)

I have a macro that can insert any number of desired columns but i need the
formula in column C to update and include the new inserted columns. I would
then need to paste this all the way down column C (but only in certain cells).

Auto-update column formula
 

Why not use the formula:
=SUMPRODUCT(A$1:B$1,A2:B2)

Then, if you insert columns between A and B, the formula will automatically
expand?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Alex" wrote:

I have a simple formula as follows
A B C
1 100 200
2
3 4 5 (4*100)+(5*200)

I have a macro that can insert any number of desired columns but i need the
formula in column C to update and include the new inserted columns. I would
then need to paste this all the way down column C (but only in certain cells).