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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- Whitoja
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- Whitoja
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
