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

Please Login or Register  to view this content.

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