sum formula in each column at lastrow + 1

[sintek]

Hi All

How do I insert a formula in columns A to E at next empty row (lastrow + 1) of each column i.e. A2:A & lrow + 1, then B2:B & lrow + 1 etc

Please Login or Register  to view this content.

[Zer0Cool]

Depends if the last rows is the same for each or differs column to column.

If its the same you typically get the last row before your and store it in a variable. If its not the same in each column you incorporate the last row portion in your loop.

I would use the .offset method of the range property. Offset by 1 row from the last cell in that column. Also your formula should not also include the last row +1 as it would be circular if it includes itself.

[sintek]

Hi Zer0Cool

Lastrow is same for each column

[sintek]

Tried this, getting zero's

Please Login or Register  to view this content.

[sintek]

Thanks i figured it out

Please Login or Register  to view this content.