View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
thorsten
 
Posts: n/a
Default How can I use variables in formulas in VB?


Hello,
I would like to integrate variables in formulas in Visual Basic, but I
don't now how to do.

My current problem is that I have to use the VLOOKUP-command in a loop,
but I can't find the solution how to define the "table_array"-entry as a
range that is changing.

So, how can I define a range (where I include my varibles) and what
command do I need to use this range in my formula?
Please help me...


Thanks a lot,

Thorsten


--
thorsten
------------------------------------------------------------------------
thorsten's Profile: http://www.excelforum.com/member.php...o&userid=34496
View this thread: http://www.excelforum.com/showthread...hreadid=542619