Thread: Not filtering by date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter Grebenik[_2_] Peter Grebenik[_2_] is offline
external usenet poster
  
Posts: 9
Default Not filtering by date
Looks to me as if your FilterRange ( = Range("A1:A" & LR)) only
selects column A, so your Field:=9 selects a column which is not in the
FilterRange.

Peter

Reply With QuoteReply With Quote