filter using VBA
 

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

filter using VBA
 

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

filter using VBA
 

Just to supplement, what you will do manually will select the top left cell
of your data in the header row and do

Data=Filter=Autofilter
select the dropdown in column A and select "yes"

It isn't clear that you know how to filter manually - but if you do, then
you can ignore this.

--
Regards,
Tom Ogilvy


"Harald Staff" wrote in message
...
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