Creating a List From Worksheets in a WorkBook
If I select "N" worksheets in my workbook, is there a way to create a "list"
of the worksheet names ? For example if I select worksheets named work1,work2,work3, I am trying to create a list like this: work1 work2 work3 Thank you in advance ? |
Creating a List From Worksheets in a WorkBook
You need VBA, Chip Pearson has an example how to return all sheet names
http://www.cpearson.com/excel/excelM.htm at the bottom of the page called sheet names -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "carl" wrote in message ... If I select "N" worksheets in my workbook, is there a way to create a "list" of the worksheet names ? For example if I select worksheets named work1,work2,work3, I am trying to create a list like this: work1 work2 work3 Thank you in advance ? |
All times are GMT +1. The time now is 06:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com