Thread: Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!
View Single Post
  #2   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!!!
hi Swingleft,

replace
Range(C2.Address).Offset(0, -9).Value = ""
by
Cells(C2.Row, 1) = ""

--
isabelle

Reply With QuoteReply With Quote