View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] amorrison2006@googlemail.com[_2_] is offline
external usenet poster
 
Posts: 53
Default Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........

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?


On 7 Jun, 21:17, Ken wrote:
How about getting rid of the blanks, then using the Excel subtotaling
functionality?

On Jun 7, 3:52 pm, "



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


Can someone help?


thanks alot


Andrea- Hide quoted text -


- Show quoted text -