Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
routing email thorugh excel | Excel Discussion (Misc queries) | |||
How do I modify charts thorugh VB | Excel Programming | |||
How can the count of filtered records always display? | Excel Worksheet Functions | |||
record of records count for display... | Excel Programming | |||
Count Records & Display MsgBox | Excel Programming |