XL97 How to find first sheet in workbook using VBA 1

[vaneagle]

Hi,

Does anyone know how to find, using VBA, the first sheet in a workbook?

Issue is that the name of the sheet could be anything. Purely depends on what the user decides to call it!!

Thansk in advance...

 

[dan1967]

You could try:

Dim SName As String
ActiveWorkbook.Sheets(1).Select
SName = ActiveWorkbook.Sheets(1).Name

This should select the first worksheet and populate the variable SName with the sheet name for later use.



Dan.

 

[vaneagle]

Excellent.

Thanks for that Dan... have a star!!

 

[dan1967]

Thanks for the star. Good luck.


Dan.