Maybe you need

ActiveSheet.Range("A1").Formula = "=VLOOKUP(""" & _
strLookValue(intLookNum) & """,Setup!A1:A15,2,FALSE)"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sune Fibaek" wrote in message
...
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