Problem with Auto Filter and Macro
 

I have a macro that was rud fine until data was added to one of the tabs. The
data was added to data that was already on the data, at the bottom. The
proble we are having now is that the macro is not seeing these data and even
when we run the auto filter on one of the columns in the tab. There are
significant number of data that is not showing up in the dropdown auto filter
list.
Last time, someone suggested to check and make sure that the list doesn't
contain any blank cell. I found one and we added date in it but that didn't
fix the problem. Does anyone know what might be going on here. I am
completely stompped.
Please help

Problem with Auto Filter and Macro
 

"Ayo" wrote in message
...
I have a macro that was rud fine until data was added to one of the tabs.
The
data was added to data that was already on the data, at the bottom. The
proble we are having now is that the macro is not seeing these data and
even
when we run the auto filter on one of the columns in the tab. There are
significant number of data that is not showing up in the dropdown auto
filter
list.
Last time, someone suggested to check and make sure that the list doesn't
contain any blank cell. I found one and we added date in it but that
didn't
fix the problem. Does anyone know what might be going on here. I am
completely stompped.
Please help

Ayo Hi

There is an upper limit to the number of individual discrete values the
Excel auto filter will display.

For example in you populate a single coloumn with numbers in the series 1 to
65536 then apply an autofilter on row one you will find only the first 1000
discrete items displayed in the pull down box.

Undisplayed items can be displayed by use of the custom option for
filtering in the pull down menu of the auto filter.

Good Luck :)

N10