have you looked into using Data - Subtotal from the XL menu. You would need
to remove your blank lines before you start, but it does exactly what you are
asking without any code...
--
HTH...

Jim Thomlinson


"simplymidori" wrote:

A B C D E F.... N O P Q R S T
a
a
a
Subtotal
b
b
b
b
Subtotal


Yes to your question. Thanks!
"Jim Thomlinson" wrote:

I am not too sure exactly what you want. Are you trying to add subtotals each
time a blank cell is found in column A or just what? Can you post some kind
of example?
--
HTH...

Jim Thomlinson


"simplymidori" wrote:

I'm looking for a macro that will add a row if column A is blank and to auto
sum columns N thru T. This would be most helpful.

Thank you.