Thread: check value with array, Application.Match
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Przemek Przemek is offline
external usenet poster
  
Posts: 16
Default check value with array, Application.Match
Hi Tom, it's still doesn't work as I want to. E.g. if in rngCell is
value TU, it's still copy that row to wsA sheet. What I want to achieve
is, that all rows with RngCell.Value, which match one of array's member
will be copied to sheet wsA, others rows to sheet wsB.

Przemek

Reply With QuoteReply With Quote