Thread: Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!


you can use the MATCH function, if it's whole value of a cell that is searched

With Sheets("Spelers")
nLine = .Range("J" & Application.Match(SPELER, .Range("J1:J65000"), 0))
.Cells(nLine, 1) = ""
End With

--
isabelle


Reply With QuoteReply With Quote