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.
Restating,I would would like to be able to go to any worksheet in my workbook and perform a sorting operation and then go to a specified worksheet and copy information there and return to the prior worksheet to use that copied information.
Any help would be much appreciated.
Tommy
Restating,I would would like to be able to go to any worksheet in my workbook and perform a sorting operation and then go to a specified worksheet and copy information there and return to the prior worksheet to use that copied information.
Any help would be much appreciated.
Tommy