Sum Unspecified Range

[timbo1957]

Hi,

I have a column if data in Column AG which varies in length from month to month.

I need a macro that will sum the column in the cell below that last cell containing data in that column. i.e. Sum(ag2: end of column).

Could anyone help please?

Many thanks

[JosephP]

Please Login or Register  to view this content.

oughta do it

[kvsrinivasamurthy]

You can try this formula.

Please Login or Register  to view this content.