View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sune Fibaek Sune Fibaek is offline
external usenet poster
 
Posts: 38
Default 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