Selecting Sheets all the before a particular sheet

[BALA1983]

Hi,


I have a workbook with 1000 of Sheets, and there will be a sheet called "Main". Now I want to select all the sheets before this "Main" Sheet and move the selected sheets along with that "Main" to a new workbook.

Thanks
Balamurugan

[jindon]

You left these with no reaction.

https://www.excelforum.com/excel-gen...ification.html
https://www.excelforum.com/excel-pro...es-values.html
https://www.excelforum.com/excel-for...specified.html
https://www.excelforum.com/excel-pro...ed-coding.html

and more... too many... out of only 49 posts.