How to display count of records thorugh macro
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 |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com