Thanks Dave, I just required the Filtermode function this time, however I
have noticed in both Mike and your replies you have used If and End If where
as I have just used the line 'If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData', without using the End If statement What is the
difference between the two and when and why should I be using End If.

Mark

"Dave Peterson" wrote:

With worksheets("Sheet9999")
'to remove the filter and the arrows
.AutoFilterMode = False
'or to just show all the data
If .FilterMode Then
.ShowAllData
End If
End With

RN Mark wrote:

Using a macro how can I check a worksheet to see if an autofilter is in place
and then show all data.

--

Dave Peterson