VishalkumarT
04-23-2007, 09:18 AM
Dear Friends
I need to re-arrange the worksheets in a workbook.
I have two workbooks, having same number of worksheets with same names, but they are placed in randomly.
So I will take first Workbook as a reference and I need to change the places of worksheets in the second workbook as per the places of worksheets in the first workbook.
Please drop few lines/ a code for this problem.
Thank you in advance.
Rgds
Vishalkumar
I need to re-arrange the worksheets in a workbook.
I have two workbooks, having same number of worksheets with same names, but they are placed in randomly.
So I will take first Workbook as a reference and I need to change the places of worksheets in the second workbook as per the places of worksheets in the first workbook.
Please drop few lines/ a code for this problem.
Thank you in advance.
Rgds
Vishalkumar