Excel Sheets

[cg084]

Hello,

I am trying to find the name of the 1st sheet in an Excel workbook. Currently i am opening several excel spreadsheet and need to be able to id the 1st sheet of each one and for it to select that sheet. e.g Sheet 1 in a default new spreadsheet.

Thank you

 

[Molby]

Try:

sub nameofsheet
nam$ = Sheets(1).name
end sub

 

[cg084]

Molby,

Thank you it works great now.

Cheers