Have you been deleting names from your workbook indiscriminately?

Maybe with code like this:

Option Explicit
Sub testme()
Dim myName As Name
For Each myName In ActiveWorkbook.Names
myName.Delete
Next myName
End Sub


If yes, then you could have deleted a hidden name created by excel.

Maybe this'll help...

Select your cells with the arrows -- just the header row is enough.

Then Insert|name|Define
in the names in workbook box, type this:

'Sheet1'!_FilterDatabase

(change sheet1 to match your worksheet name.)

Caroline Lackey wrote:

I've been using the same filtered worksheet all day and it has filtered to my
chosen item in the drop down list. All of the sudden, when trying to go from
one filtered item to the next, the filtered list doesn't appear when I try
clicking on the triangle. No changes have been made to the workbook and
freeze panes isn't on. Has anyone else had this happen? Is it a bug? The
only way of getting them back on is to unfilter the entire area, unhide the
rows, which are stuck to the last filtered items, and then reapply filters.

--

Dave Peterson