B
BVinson
I am writing a macro in Excel and I have a workbook that has worksheets with
multiple tabs. (An example of the tab names is: VFD11, VFD2, VFD1, VFM42,
VFM2).
Each tab has a three letter prefix (ex. VFD, VFM) and I have to sort
worksheets with the same prefix by ASCII.
I have already written code that groups the tabs with the same prefix
together in the workbook, now I need to sort those individual groups by ASCII
values and re-order the worksheets. I believe I need to use nested for loops
but am having trouble figuring out the structure/logic of the for loops.
Could anyone help me with this? If you need more explanation please ask, it
was difficult for me to explain this via text.
Thank you in advance!
multiple tabs. (An example of the tab names is: VFD11, VFD2, VFD1, VFM42,
VFM2).
Each tab has a three letter prefix (ex. VFD, VFM) and I have to sort
worksheets with the same prefix by ASCII.
I have already written code that groups the tabs with the same prefix
together in the workbook, now I need to sort those individual groups by ASCII
values and re-order the worksheets. I believe I need to use nested for loops
but am having trouble figuring out the structure/logic of the for loops.
Could anyone help me with this? If you need more explanation please ask, it
was difficult for me to explain this via text.
Thank you in advance!