| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter - How to determine number of records found
I would like to display a message containing the number of records found by
an autofilter run from vba How do I count the records ? Regards & TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
AutoFilter - How to determine number of records found
Use ...
MsgBox Application.WorksheetFunction.Subtotal(3, Range("A:A")) where A:A is the range you want to count. -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "JRB @eclipse.co.uk" wrote: I would like to display a message containing the number of records found by an autofilter run from vba How do I count the records ? Regards & TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
AutoFilter - How to determine number of records found
Exactly what I needed - Muchly Grateful
BTW - No 'Yes' at bottom of the post "Gary Brown" wrote in message ... Use ... MsgBox Application.WorksheetFunction.Subtotal(3, Range("A:A")) where A:A is the range you want to count. -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "JRB @eclipse.co.uk" wrote: I would like to display a message containing the number of records found by an autofilter run from vba How do I count the records ? Regards & TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get number of filtered records found displayed in a cell? | Excel Worksheet Functions | |||
| In Excel, How do I get AutoFilter to provide# of records found? | Excel Discussion (Misc queries) | |||
| How to change left bottom note that tell number records found? | New Users to Excel | |||
| How to "Capture" Records Found Number During AutoFilter | Excel Programming | |||
| Advanced Filter: Number of Records Found | Excel Discussion (Misc queries) | |||
Linear Mode
