Thanks, Chip.

I was afraid of this.

I know it is possible to compare the number of visible rows & the number of
total rows.
They are not equal after a filter, but equal when you choose All.

I am contemplating a check on this but am not sure the best way to implement
it.

Any thoughts?

The worksheet is a data entry sheet. With a scroll to make sure the last
row is in view and selected. But when any filter is selected, it would be
nice if the scroll could revert to the headers and show the first visible
row.

Appreciate your comments...

--
steveB

Remove "AYN" from email to respond
"Chip Pearson" wrote in message
...
There is no event capture this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"STEVE BELL" wrote in message
news:XD5Me.6765$rR4.4062@trnddc08...
Thanks in advance for any help!

I am trying to capture an Auto-Filter change on a worksheet column.
The worksheet has several columns with Auto-Filter.
When the user changes the selection in any of these - I wish to capture
the event.
And if possible to identify whether or not they selected "All".

This is in Excel 2000.

(I am familiar with worksheet event code, but can't figure out how to
capture this one)

Again - Thanks...

--
steveB

Remove "AYN" from email to respond