PUT A FORMULA INTO A VARIABLE

[gab]

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!

 

[Anthony47]

Hello gab.
Both INDEX and MATCH can be exploited in vba using Application.WorksheetFunction; for example:
VAR1 = Application.WorksheetFunction.index(1,2)

Of course you can use Application.WorksheetFunction.match(arg, matr, 0) as an argument for Application.WorksheetFunction.index

Does this help? Bye.

 

[gab]

Thanks for your reply (because i needed that code for other stuff), but for in this case is different...let me explain more:

First I had a formula which put the resul into a cell. the initial code (and IT WORKS BUT I DONT WANT IN A CELL!) was:

Cells(3,13). Activate
ActiveCell.FormulaR1C1 = "=CELL(""row"",INDEX(C[-2],MATCH(""LATE INTEREST & BK FEES :"",C[-2],0)))"

a = Cells(3, 13)
But as you see...the result is allocating in a cell, not in a variable (AND I WANT INTO A VARIABLE!,,and dont know how!). I would like something like this:


a = CELL("row",INDEX(C[-2],MATCH(""LATE INTEREST & BK FEES :"",C[-2],0)))

so the variable "a" will be equal to the formula. And that's the issue!!! thanks for any help!

 

[gab]

besides anthonym sorry if you see this topic replicate as "allocate a formula into a variable" . i'm new in mr. excel, and instead of clicking on post reply, i did on new topic. sorry