Returning worksheet name

[reggie1000]

Hello,

I have a mastersheet (charts) that runs a daily report, I add in a new worksheet everyday on the left hand side, I need have the name of the newest sheet in cell A60 in the mastersheet, if a new sheet is added then the cell must change accordingly, I have been using the following code for returning all the sheet names but the calculation time is taking too long due to the number of sheets.

Please Login or Register  to view this content.

any ideas

thanks reg

[Richard Schollar]

Hi Reg

Do you mean that the left-most sheet in the workbook will be the new sheet that has been added? If so you can just reference its index (it will be the first sheet):

Please Login or Register  to view this content.

Richard

[MickG]

Hi, Could you not do something like This:-

Please Login or Register  to view this content.

Regards Mick

[jazaddict]

To add to what RichardSchollar said....

Please Login or Register  to view this content.

will give you the name of the LAST sheet into A60