I would just do something like

activesheet.cells.autofilter

If it's filtered it will clear all the filters. If it has the dropdowns but
isn't filtered it will remove them. If it has no drop downs it will put them
on. In any case you will have an unfiltered list.

Jeff

wrote in message
oups.com...
I have a VB piece of code that runs and needs to unfilter the worksheet
data as part of it. Based on postings out here, I've seen that I
should use this bit of code:

On Error Resume Next
ActiveSheet.ShowAllData
On Error GoTo 0

The problem is that it doesn't seem to work for my worksheet, when
going through this piece of code, it appears to still leave the
filtered values on. It's o.k. to leave the drop down arrows, just need
all of the data displayed in the Active worksheet.

Any help would be greatly appreciated.

Thanks!