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: *

  • Users: uszd
  • Content: Threads
  • Order by date
  1. uszd

    Need help for "Range" problem

    I need a macro to print a range from cell "A1" to the last non-zero cell in column L. this is my vba: Sub findprint() Dim i As Integer Dim a As Integer Dim b As Integer i = WorksheetFunction.CountIf(Columns(12), 0) a = WorksheetFunction.CountA(Columns(12)) b = a...
  2. uszd

    VBA automatically apply two macros in multiple worksheets

    I have macro1 and macro2 in a workbook with 10 sheets. 3 worksheets' name begins with "a", two begins with "b". Does anyone know how automatically go through all 10 sheets and apply macro1 to 3 "a*" sheets , macro2 to 2 "b*" sheets? Thanks!

Part and Inventory Search

Back
Top