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
Thanks in Advance...![]()
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])"
Bookmarks