| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
I see my response to your last post worked because your using the code. I
thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
Thanks Mike,
Still that problem exist . When I am filtering the record the subtotal will disappear. But at the same time I am removing the all filter , the subtotal wil be shown. Please help Mike With thanks Pol "Mike H" wrote: I see my response to your last post worked because your using the code. I thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
How are you filtering? on the worksheet or with a macro. In either case if
you include the formula cell in the filtered range you'll hide it Mike "pol" wrote: Thanks Mike, Still that problem exist . When I am filtering the record the subtotal will disappear. But at the same time I am removing the all filter , the subtotal wil be shown. Please help Mike With thanks Pol "Mike H" wrote: I see my response to your last post worked because your using the code. I thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
I am filtering manually. the subtotal is showing in O194 cell. But When I am
filtering this rows will disappear. That is the problem . End of the rows is not working properly while filtering with thanks Pol "Mike H" wrote: How are you filtering? on the worksheet or with a macro. In either case if you include the formula cell in the filtered range you'll hide it Mike "pol" wrote: Thanks Mike, Still that problem exist . When I am filtering the record the subtotal will disappear. But at the same time I am removing the all filter , the subtotal wil be shown. Please help Mike With thanks Pol "Mike H" wrote: I see my response to your last post worked because your using the code. I thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
Leave a gap of 1 row then the formula won't be filtered out
lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 2).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Mike "pol" wrote: I am filtering manually. the subtotal is showing in O194 cell. But When I am filtering this rows will disappear. That is the problem . End of the rows is not working properly while filtering with thanks Pol "Mike H" wrote: How are you filtering? on the worksheet or with a macro. In either case if you include the formula cell in the filtered range you'll hide it Mike "pol" wrote: Thanks Mike, Still that problem exist . When I am filtering the record the subtotal will disappear. But at the same time I am removing the all filter , the subtotal wil be shown. Please help Mike With thanks Pol "Mike H" wrote: I see my response to your last post worked because your using the code. I thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
Thanks a lot Mike..
Now I hope it will work. But what is the problem on previous rows. I can't locate the exact problem. So is not possible to show just that bottom of that column ? "Mike H" wrote: I see my response to your last post worked because your using the code. I thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
When you filter Excel filters the continuous range so you must leave a gap to
exclude the formula from the filter. Mike "pol" wrote: Thanks a lot Mike.. Now I hope it will work. But what is the problem on previous rows. I can't locate the exact problem. So is not possible to show just that bottom of that column ? "Mike H" wrote: I see my response to your last post worked because your using the code. I thought it hadn't helped because you never bothered responding. Perhaps this will solve your currect problem lastrow = Cells(Rows.Count, "O").End(xlUp).Row Range("O" & lastrow + 1).Formula = "=SUBTOTAL(9,O3:O" & lastrow & ")" Please feel free to let me know if it does!! Mike "pol" wrote: 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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To show the sunbtotal in retrieved rows
Thanks Mike, Very much
Is any other mathod to show the subtotal thru macros just below the column while filtering With thanks Pol "pol" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
