Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zero records in Filter
use something like this:
Dim rg As Excel.Range Range("A1").AutoFilter Field:=1, Criteria1:="axa" Set rg = Application.Intersect(Range("A:A"), Range ("A1").CurrentRegion).SpecialCells(xlCellTypeVisib le) MsgBox rg.Count - 1 & " records found" Francisco Mariscal -----Original Message----- Hi all How can I find out if AutoFilter returned 0 records using VBA, I just want to say If zero records found msgBox else my remaining code TIA Soniya . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Filter out unwanted records | Excel Discussion (Misc queries) | |||
Number of records after filter | Excel Worksheet Functions | |||
Filter Unique Records | Excel Discussion (Misc queries) | |||
How can I always get subtotals (4 of 12 records)when I filter a sh | Excel Discussion (Misc queries) | |||
Why does it say "Filter mode" instead of "X of Y records"? | Excel Worksheet Functions |