Thread: Re : Excel AutoFilter being Toggled of VisibleDropDown
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mitesh Khatri Mitesh Khatri is offline
external usenet poster
  
Posts: 1
Default Re : Excel AutoFilter being Toggled of VisibleDropDown
Hiiii
For check the state of auto filter use the following commands
if activesheet.row(5).AutoFilterMode=False then
activesheet.row(5).AutoFilter()
end if

With Regards
Mitesh Khatri

India
Reply With QuoteReply With Quote