| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Total but not GRAND Total rows
Once a sheet is SubTotalled, need to put some formulas underneath each row
where Total occurs, but not under the Grand Total riow. Note: The text in every total row contains a dash, ie "-" . Tried the following, but it doesn't work .... For Each c In Range("a2:a500") If InStr((c.Value), "*-*Total") Then c.Offset(1, 0).EntireRow.Insert Shift:=xlDown Thanx in advance for any assistance. - Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Total but not Grand Total rows | Excel Programming | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| % of Running Total to Grand Total in Pivot Table | Excel Programming | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
![MikeF[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
