Being the newcomer to Excel VBA, I was wondering if there's a way o
knowing when the Autofilter has been changed, and if so, how??

What I'm trying to accomplish is this: I have a spreadsheet that i
essentially a BOM of extracted data from AutoCAD. This data consist
of a room numbers, room names, # of PCs, # of phones, etc... If th
user filters the list by, let's say the Room Number, I'd like to b
able to then count how many of each item are in that room. I know ho
to get the visible rows but I don't know how to capture when the filte
has been changed.

Any help will be greatly appreciated.

Thanks in advance!

Matt

--
Message posted from http://www.ExcelForum.com