Hello,
Trying to enter a formula =SUBTOTAL(109,[BookCreditAmount])[/u]), using VBA.
Tried the following, (and more), and it doesn't work.
' Range("O" & lRowDump + 1, "O" & lRowDump + 1).Formula = "=SUBTOTAL(109,[BookCreditAmount])"
' Selection.FormulaR1C1 = "=SUBTOTAL(109,[BookCreditAmount])"
' Range("N" & lRowDump + 1, "N" & lRowDump + 1).Formula = "=SUBTOTAL(109,[BookDebitAmount])"
' Range("N" & lRowDump + 1, "N" & lRowDump + 1).Select
' Selection.FormulaR1C1 = "=SUBTOTAL(109,[BookDebitAmount])"
' ActiveCell.Formula = "=SUBTOTAL(109,[BookCreditAmount])"
Your help is appreciated.
Thank you.
If it's a field/column in a table then you would also need the table name.