Hi Jim,

I have about 200 different sections under 1 tab which needs subtotaling from
N-T. So the subtotal from the menu bar will not suffice for this task.
Inserting that extra row if and adding the subtotal fields will help.

Thanks for your suggestion.



"Jim Thomlinson" wrote:

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.