View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Cell to be activated, which is a result of a vlookup formula

Hi,
could somebody please help me with some code for a macro?

I have following formula: =VLOOKUP($H6&"-"&I6,'Stock sheet'!$A:$F,6,FALSE)

After the result is displayed, I'd like the cursor to jump to that exact
cell, which it found in 'Stock sheet'!$A:$F,6,False). I tried Goto, but it
doesn't work.

Thank you!

Regards,
Norbert


GoTo only requires the target address; - ",False" belongs to the VLOOKUP
function!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion