You said that Advanced filter was greyed out in a shared workbook. Thus,
you will not be able to overcome this by using VBA.

There has been all kinds of fast code posted for hidding rows. With no
other information, such as what code is slow, how your data is laid out,
what you are trying to do, you are invited to query the archives.

--
Regards,
Tom Ogilvy


"ram" wrote in message
...
I was looking for help on how I could advance filter a list in a shared
work
book.

When I use advanced filter I receive runtime error 1004.
If i hide rows it run very slow with 20 thousand rows.

Thanks in advance for any help.

and thanks to everyone who has helped me with this project over the last
month. It is just about complete. (until they decide to change everything)