[Solved] VBA Vlookup and complex Formula problem

[Bansheete]

Hi all,
Im trying to turn this formula:

=MID(VLOOKUP(B103;'Extracto Siebel'!$1:$1048576;5;FALSE);SEARCH("113";VLOOKUP(B103;'Extracto Siebel'!$1:$1048576;5;FALSE);1);13)

Into something i can put in a macro so it goes automatically in a range with a macro.

My problem is that "B103" is a variable and refers to 3 cells to the left of where the cell is.

So. i used this:

Please Login or Register  to view this content.

But It does not work.

This one works, but fills everything up with a Fixed reference: "$B$103"

Please Login or Register  to view this content.

Any way to do it??

Thanks in Advance!!!!

[GC Excel]

Hi,
Try using FormulaR1C1 instead. So you can use relative and/or absolute references.

Go in the cell where your formula is, then open the VBE editor immediate windows and type : Debug.Print ActiveCell.formulaR1c1
Use this result in your code :
Example :

Please Login or Register  to view this content.

[Olly]

Try:

Please Login or Register  to view this content.

[Bansheete]

Thanks!! Using R1C1 Worked!