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