writing formula in VBA

Mar 14th, 2002, 09:54 AM

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)"

Mar 14th, 2002, 03:43 PM

Try using the macro recorder to get the required code.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 09:54 AM	#1
Guest Posts: n/a	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)"

Mar 14th, 2002, 03:43 PM	#2
Guest Posts: n/a	Try using the macro recorder to get the required code.