Vaiable in range().formula
Hi
This is probably quite trivial, but how do I do somthing like this:
ActiveSheet.Range("A1").Formula "=VLOOKUP(" & strLookValue(intLookNum) &
",Setup!A1:A15,2,FALSE)"
I am trying to add a variable from an array to the VLOOKUP formula.
/Sune
|