Record a macro while doing it manually and you have it.

HTH. Best wishes Harald

"confused" skrev i melding
...
Hi,

Is it possible to use VBA to filter a worksheet? ie press a button which
will filter a worksheet so that only those rows with columnA = 'yes' are
displayed?

thanks for any help
cheers