HI!!
I have the following formula
Activecell.FormulaR1C1 = "=CELL(""row"",INDEX(C[-2],MATCH(""INTEREST:"",C[-2],0)))"
And is working and allocating the result into a cell, but i want the result fo the formula into a variable for working in vba i.e X = "=CELL(""row"",INDEX(C[-2],MATCH(""LATE INTEREST & BK FEES :"",C[-2],0)))" and i just dont know how to do it
Thanks for any help!
I have the following formula
Activecell.FormulaR1C1 = "=CELL(""row"",INDEX(C[-2],MATCH(""INTEREST:"",C[-2],0)))"
And is working and allocating the result into a cell, but i want the result fo the formula into a variable for working in vba i.e X = "=CELL(""row"",INDEX(C[-2],MATCH(""LATE INTEREST & BK FEES :"",C[-2],0)))" and i just dont know how to do it
Thanks for any help!