try
Sub showall()
On Error GoTo away
ActiveSheet.ShowAllData
away:
End Sub

--
Don Guillett
SalesAid Software

"JosiePosie21" wrote in message
...
I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to "Show All" throughout the
spreadsheet without going to each individual column and selecting it. Is
there a way to "Globally Show All"?