G
Guest
Guest
Here is an extract of some code which is trying to insert the word "TOTALS" into a cell whose position can change (Hence the variable TotalRow). This part works!
However I'm also tring to insert a formula in the same row starting in Col N as far over as AH.
Please help me. Thank you
Range("M" & TotalRow).Value = "TOTALS"
Range("N" & TotalRow, ("AH" & TotalRow)).Formula = "=SUBTOTAL(9, "N2:N" & LastRow)"
However I'm also tring to insert a formula in the same row starting in Col N as far over as AH.
Please help me. Thank you
Range("M" & TotalRow).Value = "TOTALS"
Range("N" & TotalRow, ("AH" & TotalRow)).Formula = "=SUBTOTAL(9, "N2:N" & LastRow)"