Thread: Cell to be activated, which is a result of a vlookup formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norbert[_4_] Norbert[_4_] is offline
external usenet poster
  
Posts: 52
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
Reply With QuoteReply With Quote