Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal

A

amorrison2006

Have looked around on the posts and not found anything on this,

Can someone help?

thanks alot

Andrea
 
K

Ken

How about getting rid of the blanks, then using the Excel subtotaling
functionality?
 
A

amorrison2006

I really only want sum calculations.....I cant get rid of the line
because it's a report......

can you help please with a macro do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference to next non-blank cell 1
Create if partial match then copy and paste data from one cell to another 1
Find first non-blank cell 4
Insert a space in all blank cells of the first column 3
VBA Code and Summing Next Non-Blank Cell in Column 9
first non blank cell 3
Insert row after blank cell encountered 6
End(xlDown) giving me blanks 1

Top