Activecell formular1c1 define with variables

[Benic]

Hello,

I have formula that works:

ActiveCell.FormulaR1C1 = "=FuzzyVLookup(RC[-1],'[File.xlsm]Sheet1'!R1C1:R200C2,2,,,3)"

I would like to use variable instead of RC[-1], how can I do it?

thanks

 

[BarryL]

what value are you looking to replace the RC[-1]?

 

[Benic]

For ROW value is always the same = 1,
for COLUMN I would like to select from TextBox - from A to M,

thanks

 

[Benic]

I use it like this:

ActiveSheet.Range(Kolona2 & Raspon1).Select

ActiveCell.FormulaR1C1 = "=FuzzyVLookup(RC[-1],'[BAZA_USPOREDBA.xlsm]BAZA_KOMPLET'!R1C1:R200C2,2,,,3)"

I have an issue with RC[-1], can I somehow instead of it put something like:

ActiveSheet.Range(Kolona2 & Raspon1).Offset(0,-1) and instead of -1 use variable?

thanks

 

[Benic]

I have made it work,

Instead of:

ActiveCell.FormulaR1C1 = "=FuzzyVLookup(RC[-1],'[BAZA_USPOREDBA.xlsm]BAZA_KOMPLET'!R1C1:R200C2,2,,,3)"

This works:

ActiveCell.Formula = "=FuzzyVLookup(" & Kol & "" & Rasp & ",'[BAZA_USPOREDBA.xlsm]BAZA_KOMPLET'!A1:B200,2,,,3)"


regards