After autofiltering a worksheet,one name does not show up in the dropdown list.
This is very weird and first time it happes.
I tried : unfilter and autofilter again= still name does not show.
unfilter, erasing and writting the name again, filtering= same
results
Could these be reasons ? 1500 rows,
having blank rows in my data. But is the first time it happens or I notice.
I also installed a couple of add-ins but not recently: CFPlus ( but is off)
and Case L.
Also got a couple of non related macros and Vlookups.
Out all my workbooks and worksheets this is the only one that happens.
Excell 2003, XP. Thanks.