Need to code a sum formula into a cell using R1c1 formula
The foruula will be placed in row 3. The range will be from row 5 to the last row of data in the column (lRow).
All in the same column. What I have does not work:
fRow = 5
lRow = Range("A65535").End(xlUp).Row
pA = "=sum(RC:R[lRow]C)"
Cells(fRow - 2, 242).FormulaR1C1 = pA
I receive a run-time error "10004". Prgram works if I substite a number for lrow but I need a varible tht changes daily and want to keep lRow