I have a workbook that I a having difficulty in sorting the worksheets. I want to sort the sheets starting after sheet 3 which is called "Master". I had it working where it sorted it first time that I ran the macro but the when a new sheet was inserted after the Master sheet then the sort all went wrong.
Here's the current code and I have attached an example workbook. Would appreciate some help
Please Login or Register to view this content.
Hi,
Try this code which I had on hand (on my PC)
Adjust as needed...
It will sort from sheet 4 to the end...
Please Login or Register to view this content.
Regards,
Rudi
You could use this macro.
The LT function tests if the sheet name is numeric, to avoid a purely alphabetic sort where "12" < "2"
Please Login or Register to view this content.
Last edited by mikerickson; 07-06-2014 at 11:59 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
double post
Great job thanks you. I have got my original code to work by replacing the "Ucase" with "Val" and this worked. How would your code look hard coded to descending rather than having the question box
many thanks Mark
Just set Descending to True.
Or omit the Descending variable all together and change this line
Please Login or Register to view this content.
Thanks All
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks