AutoFilter
 

Get rid of the arrows????
ActiveSheet.AutoFilterMode = False
It won't hurt if the sheet doesn't have autofilter applied.

Keep the arrows, but show all the data???

With ActiveSheet
If .AutoFilterMode Then
If .FilterMode Then
..ShowAllData
End If
End If
End With





Gareth wrote:


How, by code, can I check if autofilter is on?

If it is on, switch it off.

Thanks in advance.

Gareth


--

Dave Peterson