View Single Post
  #6   Report Post  
Old February 4th 20, 09:34 AM posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default Cell to be activated, which is a result of a vlookup formula

Error is because Find() failed to Set c

try...

With Sheets("Stock sheet")
Set c = .Range("A:A").Find(myStr)

If Not c Is Nothing Then Application.Goto .Range("F" & c.Row)
End With


--
Garry

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