| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To show the sunbtotal in retrieved rows
Please help to show the subtotal under the last column + 1 of O . I am using
the following command. But the problem is while filtering the record the subtotal is not displayed in the last column of the retrieved rows. Please help Range("O" & LastRow).Select ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & LastRow - 1 & ")" With thanks Pol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using filename retrieved from GetOpenFilename | Excel Discussion (Misc queries) | |||
| Can the author of an .XLS be found and retrieved ? | Excel Discussion (Misc queries) | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Threaded Mode
