Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 7th 07, 08:52 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 53
Default Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........

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

Can someone help?

thanks alot

Andrea


  #2   Report Post  
Old June 7th 07, 09:17 PM posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 207
Default Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between.........


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



  #3   Report Post  
Old June 7th 07, 09:27 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
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 -





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Formula to display blank cell if named range is blank Rachael F Excel Worksheet Functions 3 February 22nd 08 06:05 PM
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste JenIT Excel Programming 4 April 12th 07 08:56 PM
Copy to first Blank cell in Colum C Non blank cells still exist be Ulrik loves horses Excel Programming 2 October 8th 06 07:35 PM
How can I have a zero in a blank cell at start up Mike Davis Setting up and Configuration of Excel 1 September 1st 06 10:36 AM
how to get excel to display blank if reference cell blank silent1(not) Excel Worksheet Functions 1 December 2nd 05 03:49 PM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017