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 Mike Lewis 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. Whitoja

    Sorting code that will work on multaple sheets

    My situation is that i want to be able to sort whatever sheet i happen to be on at any given time, not "sheet1" all the time for example. the next time i want to sort it might be "sheet5" but i don't want to have to specify the sheet in the code, i need some generic reference to whatever sheet i...
  2. Whitoja

    Sorting code that will work on multaple sheets

    Thanks Skip, The code is below, it's only the "sort" part that i'm talking about. The "S_2" reference is the worksheet name but i will need to go to other worksheets and sort.So,somehow the worksheet reference has to generic, not a specific sheet like S_2. Sub Sort() ' ' Sort Macro ' '...
  3. Whitoja

    Sorting code that will work on multaple sheets

    I have used a recorded macro to alphabetize a column of names (range [A1:A100], A to Z) on a single Excel worksheet. I am about to add additional worksheets having columns of names in the same range. I don't know how to code this function so that it will work on all the worksheet, not all at the...
  4. Whitoja

    Return to prior worksheet after sub

    I have VBA code to sort a column of names in whichever worksheet I have up, not specified by Sheets("xxx").Select. I would like to imbed a sub that selects a specific worksheet where info may be copied and used on the original worksheet without having to specify the original worksheet...

Part and Inventory Search

Back
Top