Hi
I am having a very perculiar problem. When I perform an Autofilter on one
of the columns in excel that I am working on, abunch of the data in that
column are not showing up in the dropdown list of the autofilter, even
though the data is there in the coulmn. This is affecting a macro I am run
because the macro is suppose to use the data in the column to fill a form;
this is not happening and I suppect it is because the data are not showing up
in the autofilter. I have never seen something like this before in excel.
Does anyone know what is going on or what the problem is. Thanks

hi Ayo

See
http://www.contextures.com/xlautofilter02.html#Limits

Or you have a empty row in your table



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ayo" wrote in message ...
Hi
I am having a very perculiar problem. When I perform an Autofilter on one
of the columns in excel that I am working on, abunch of the data in that
column are not showing up in the dropdown list of the autofilter, even
though the data is there in the coulmn. This is affecting a macro I am run
because the macro is suppose to use the data in the column to fill a form;
this is not happening and I suppect it is because the data are not showing up
in the autofilter. I have never seen something like this before in excel.
Does anyone know what is going on or what the problem is. Thanks

Thanks Ron. It's the empty row problem.

"Ron de Bruin" wrote:

hi Ayo

See
http://www.contextures.com/xlautofilter02.html#Limits

Or you have a empty row in your table



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ayo" wrote in message ...
Hi
I am having a very perculiar problem. When I perform an Autofilter on one
of the columns in excel that I am working on, abunch of the data in that
column are not showing up in the dropdown list of the autofilter, even
though the data is there in the coulmn. This is affecting a macro I am run
because the macro is suppose to use the data in the column to fill a form;
this is not happening and I suppect it is because the data are not showing up
in the autofilter. I have never seen something like this before in excel.
Does anyone know what is going on or what the problem is. Thanks