Convert formula from R1C1 to A1

[hkbhansali]

Hi,

I have record a macro with formula but macro record its in R1C1 style, I want to convert it in A1 style, How ?

Any Help ?

here is recorded macro code

Range("K2").Select
    ActiveCell.FormulaR1C1 = _
        "=SUMIFS('TRADE-(FEBRUARY-18)'!R3C17:R22000C17,'TRADE-(FEBRUARY-18)'!R3C2:R22000C2,RC[-10],'TRADE-(FEBRUARY-18)'!R3C4:R22000C4,RC[-8],'TRADE-(FEBRUARY-18)'!R3C5:R22000C5,RC[-7],'TRADE-(FEBRUARY-18)'!R3C6:R22000C6,RC[-6],'TRADE-(FEBRUARY-18)'!R3C7:R22000C7,RC[-5])"

Thanks in Advance...

[jeffreybrown]

Have a look at this...

Example: debug.print Application.ConvertFormula(formula:= "=LEFT(RC[-1],3)",fromReferenceStyle:=xlR1C1, toReferenceStyle:=xlA1)

[Marc L]

Hi !

Just select cell and from VBE Immediate windows enter ?activecell.formula !

[hkbhansali]

hello...

Sorry, I can't understand