I've got this strange problem. I've highlighted an area (A1:H10 for example) which has data in it and selected auto filter. I would usually expect to be able to select from a drop down box from the title row but no drop down box or indicator of a drop down box exists. I go back to turn auto filter on again but I find that it has been turned on. I've been doing this with success for the last month with this spreadsheet but it just stopped working today after a made a few VBA changes to some code (not worksheets or workbook events but just module stuff).

Any ideas on why auto filter doesn't appear to work??

Cheers!