Macro to AddRow and Autosum

[simplymidori]

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.

 

[Jim Thomlinson]

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?

 

[simplymidori]

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]

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...

 

[simplymidori]

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.