Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for subtotal
Please help in the following example how I can give end of column
instead of O193 ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,O3:O193)" with thanks and regards Pol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for subtotal
Hi,
Maybe this lastrow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Mike "pol" wrote: Please help in the following example how I can give end of column instead of O193 ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,O3:O193)" with thanks and regards Pol |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for subtotal while filtering
Thanks Mike,
When I am using that formula , the subtotal is showing just last line of the column. I want the the subtotal should be shown at the end of the data. But when I am executing that formula , the result will be overwritten the data on the last line . So I given the following mathod but it is not working when I am filtering With ActiveSheet LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row .Range("O2:O" & LastRow).FormulaR1C1 = .Range("O2").FormulaR1C1 End With Range("O" & LastRow + 1).Select LastRow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & LastRow & ")" Please Help "Mike H" wrote: Hi, Maybe this lastrow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Mike "pol" wrote: Please help in the following example how I can give end of column instead of O193 ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,O3:O193)" with thanks and regards Pol |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for subtotal while filtering
see your latest post
"pol" wrote: Thanks Mike, When I am using that formula , the subtotal is showing just last line of the column. I want the the subtotal should be shown at the end of the data. But when I am executing that formula , the result will be overwritten the data on the last line . So I given the following mathod but it is not working when I am filtering With ActiveSheet LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row .Range("O2:O" & LastRow).FormulaR1C1 = .Range("O2").FormulaR1C1 End With Range("O" & LastRow + 1).Select LastRow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & LastRow & ")" Please Help "Mike H" wrote: Hi, Maybe this lastrow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Mike "pol" wrote: Please help in the following example how I can give end of column instead of O193 ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,O3:O193)" with thanks and regards Pol |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help for subtotal while filtering
"Mike H" wrote: see your latest post "pol" wrote: Thanks Mike, When I am using that formula , the subtotal is showing just last line of the column. I want the the subtotal should be shown at the end of the data. But when I am executing that formula , the result will be overwritten the data on the last line . So I given the following mathod but it is not working when I am filtering With ActiveSheet LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row .Range("O2:O" & LastRow).FormulaR1C1 = .Range("O2").FormulaR1C1 End With Range("O" & LastRow + 1).Select LastRow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & LastRow & ")" Please Help "Mike H" wrote: Hi, Maybe this lastrow = Cells(Rows.Count, "O").End(xlUp).Row ActiveCell.Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Mike "pol" wrote: Please help in the following example how I can give end of column instead of O193 ActiveCell.FormulaR1C1 = "=SUBTOTAL(9,O3:O193)" with thanks and regards Pol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |