Thread
:
FormulaR1C1
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
FormulaR1C1
Haven't tried but don't think so. I usually use regular
..formula="=a1*b1"
--
Don Guillett
SalesAid Software
"Aksel Børve" wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]