Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1
Aksel
No. Excel will put quotes around L9 and give you a #NAME? error. You can use Application.ConvertFormula to covert an A1 style reference to R1C1, though. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Aksel Børve wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with FORMULAR1C1 property | Excel Programming | |||
activecell.formular1c1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming |