Using VBA, how do I detect whether a worksheet has autofilter or not?
Z Zack Barresse Feb 14, 2007 #2 Hi there, Check the AutoFilterMode property of the worksheet object. Here is an example... If Sheets("Sheet1").AutoFilterMode = True Then Msgbox "Autofilter On!", vbinformation Else Msgbox "Autofilter Off!", vbinformation End if HTH
Hi there, Check the AutoFilterMode property of the worksheet object. Here is an example... If Sheets("Sheet1").AutoFilterMode = True Then Msgbox "Autofilter On!", vbinformation Else Msgbox "Autofilter Off!", vbinformation End if HTH
