Access to info in Status Bar when in autofiltermode

[zagrijs]

:hi:

When a filter is activated a message appears in the status bar "5 of 10" cases whatever the case maybe.

Is it possible to get access to the information displayed in the status bar to be displayed e.g. in a userform?

Thanks in anticipation.

Regards

Zagrijs

[Aflatoon]

Not easily, no. You could use API calls but it would be far simpler to just count the visible rows in your code! ;)

[zagrijs]

Thanks Aflatoon.

I have been doing exactly that, i.e. counting the visible rows. I was hoping there might be a simple single command statement possible the would be "cleaner", simpler and quicker.

[Aflatoon]

What are you using? Something like:

your_range.columns(1).Specialcells(xlcelltypevisible).count
should be sufficient.

[zagrijs]

I used a loop.

I expected there should be a better way.

Thanks this makes things much easier.