Changing cell reference in a formula when inserting a row

[Apel]

I have a function Sum('1st Qtr:4th Qty'!AW1) in row 1 and dragged down 129 rows so the last reads Sum('1st Qtr:4th Qty'!AW129). If I insert a row the cell reference does not increment automatically below the insert location. How do I get it to do so. The insertion occurs when I run a macro.

[pike]

Hi Apel
try

Please Login or Register  to view this content.

hope it helps

[Apel]

Thank you.

[pike]

No thank you
....especially for marking the post