Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. froshie

    How to determine number of rows returned by a filter

    Tony, The heading of my worksheet is in Row 2. The solution you provided works when the filter does return a record. However, my code isn't working when the filter returns no record. Rows("2:2").Select Selection.AutoFilter Selection.AutoFilter Field:=9...

Part and Inventory Search

Back
Top