the "best" code is undefinable - code that does a job , and does it well,
could be defined as good - but for any problem, there will be probably many
soulutions. Th e'best' may the solution that suits the user, but everyone has
different tastes. My car is colored 'solar yellow' which I think is the best
color for it. see?

What you could use is an Advanced Filter. This gives much better control
over what comes out of the filters.


"minostrada" wrote:

hi,

I'm building a database in Excel. At the moment I use a autofilter. But the
database got so many possibilities that I'm trying to write a VB code to hide
the empty columns out of the filtered results.

Does anybody know what the best code is?

thanks for so far!