Formula with active row and column reference

[Charlene123]

I'm trying to use a macro to insert a formula. But the formula needs to reference the current row and column. Can someone me understand how to do this?

"R[-126]C1" - should be - $a & current row
"R2C" - should be - current column & $2

"=SUMIFS([Current_Firm_OS_BP1100.xlsx]Sheet1!C10,[Current_Firm_OS_BP1100.xlsx]Sheet1!C4,"">""&R2C,[Current_Firm_OS_BP1100.xlsx]Sheet1!C4,""<""&R2C+6,[Current_Firm_OS_BP1100.xlsx]Sheet1!C3,""1024"",[Current_Firm_OS_BP1100.xlsx]Sheet1!C8,R[-126]C1)"

Also, I want to insert this formula based on column E having the text "firm orders"

THANKS in advance for any help!

 

[Joe4]

Row A of current row would be: RC1
Row 2 of current column would be: R2C

See: Excel Formulas - A1 or R1C1 Notation

 

[Charlene123]

I got it! It seems so simple now that I have reviewed your link. THANK YOU!

 

[Charlene123]

With the help I have the formula figured out, but how would I use a macro to insert it into $h1:$K1 based on $A1 being a specific text ("firm orders")

 

[Joe4]

With the help I have the formula figured out, but how would I use a macro to insert it into $h1:$K1 based on $A1 being a specific text ("firm orders")

Do you mean something like:

If Range("A1")="firm orders" Then
    Range("H1:K1").FormulaR1C1=...
End If

 

[Charlene123]

Surprisingly I got this to work
Sub Macro24()
Dim lr As Long, i As Long
lr = Cells(Rows.Count, "E").End(xlUp).ROW
For i = 2 To lr
If (Cells(i, "E")) = "Firm Orders" Then Cells(i, "I").Resize(1, 40).FormulaR1C1 = _
"=formula"
Next i
Range("a1").Select
End Sub