RaulDR

Let say I have a formula in cell E1 =sum(A1Big Smile1) and another formula in cell E2 =sum(A2Big Smile2) if I insert a row between the two formula I want excel to automatically copy the formula in the inserted row



Re: Visual Studio Tools for Office auto copy of formula

Albert Raiani

When you insert a new row Excel doesn't automaticaly copy the formula down. However, after you insert the new row(s) you can just highlight cells E1, E2 and E3 and press ctrl+d to copy the formula down.

Al





Re: Visual Studio Tools for Office auto copy of formula

RaulDR

thanks Al! Smile