Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter's events
Hi,
I look up in VBA easy syntax for solution of below problem. I'd like to get some info (e.g. info about amount of selected records) after make a choice in autofilter. It should be work only if filter is selected. I would be very grateful for any help and all suggestions. Regards Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter's events
Hi Mark
Sub test() If ActiveSheet.AutoFilterMode Then MsgBox Application.WorksheetFunction.Subtotal(2, Range("A2:A1000")) Else MsgBox "No filter" End If End Sub or simply a worksheet formula in a cell: =SUBTOTAL(2,A2:A1000) -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please "Mark" skrev i melding ... Hi, I look up in VBA easy syntax for solution of below problem. I'd like to get some info (e.g. info about amount of selected records) after make a choice in autofilter. It should be work only if filter is selected. I would be very grateful for any help and all suggestions. Regards Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change XL2003 autofilter's arrow color | Excel Discussion (Misc queries) | |||
# Events over time? | Excel Discussion (Misc queries) | |||
events? | Excel Discussion (Misc queries) | |||
How do I find blank cells using AutoFilter's Custom feature? | Excel Worksheet Functions | |||
VBProject events? | Excel Programming |