Set objExcel1 = CreateObject("Excel.Application")
strPathExcel1 = "C:\temp\Test.xls"
objExcel1.Visible = True
Set objSheet1 = objExcel1.ActiveWorkbook.Worksheets(1)
objSheet1.Range("A1").AutoFilter 1,"1" '1 is the column name , 2 is the value in the field to filter
MsgBox objExcel1.WorksheetFunction.Subtotal(103, objSheet1.Range("A:A"))
Originally Posted by azad
I want to get the count of only filtered rows of excel, but unable to get... till now what i have done is opened an excel and applied a filter