Hello all,

I am feeling rather stupid right now. I have tried everything I ca
think of, but I cant get this to work.

I have a column that has about 15000 rows of tax id's. I want t
autofilter this row. but, autofilter has a max of 1000 entries. I
there a way around this, or some code I can implement to make i
recognize all of the tax id's?

TIA

Thoma

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=55383

Hi dok112

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


--
Regards Ron De Bruin
http://www.rondebruin.nl



"dok112" wrote in message
...

Hello all,

I am feeling rather stupid right now. I have tried everything I can
think of, but I cant get this to work.

I have a column that has about 15000 rows of tax id's. I want to
autofilter this row. but, autofilter has a max of 1000 entries. Is
there a way around this, or some code I can implement to make it
recognize all of the tax id's?

TIA

Thomas


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=553834