| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| How can I have a zero in a blank cell at start up | Setting up and Configuration of Excel | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
![amorrison2006@googlemail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
