Thread: filter error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karthik Bhat - Bangalore Karthik Bhat - Bangalore is offline
external usenet poster
  
Posts: 25
Default filter error
Hi

Use this code

sub ex()
set rng=range("a1:a7")
rng.autofilter
rng.AutoFilter 1, Criteria1:="2000-05"
end sub

Thanks
Karthik Bhat

Reply With QuoteReply With Quote