When we record a macro in an excel sheet, final output should be just the
count which should be displayed.
For Eg:
Selection.AutoFilter
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
Range("E1").Select
Selection.AutoFilter Field:=4, Criteria1:="Gas Turbine"
Selection.AutoFilter Field:=5, Criteria1:="=*F*", Operator:=xlAnd


After filtering the coulmns need to display the count of records.
Kindly help