A
Aksel Børve
Is it possible to mix relative ranges with other ranges?
Thanks
Sub DrillPipe1()
With Range("RngVrtDp1")
If ("RngVrtDp1") > ("I3") Then
..FormulaR1C1 = "=(RC[-1])*(L9*0,01)"
Else
..FormulaR1C1 = "=(RC[-1])"
End If
End With
End Sub
Thanks
Sub DrillPipe1()
With Range("RngVrtDp1")
If ("RngVrtDp1") > ("I3") Then
..FormulaR1C1 = "=(RC[-1])*(L9*0,01)"
Else
..FormulaR1C1 = "=(RC[-1])"
End If
End With
End Sub