reference a sheet with variable?

Hi there,

I was wondering if there was any way to reference a sheet with a variable name instead of needing to know the exact name of the sheet?

I am trying to open an individual sheet into my workbook with the code:

Please Login or Register  to view this content.

That works fine, if the sheet the person is trying to open is called "EVENTS". However I would like to implement something like

Sheets(sFileName)

to open the name of the sheet the same as the file name.

I'm not sure what you are trying to do. Does it help to know that the last three lines do the same thing?

Please Login or Register  to view this content.

if your sheet is labeled the same name as your workbook then this will work..

Please Login or Register  to view this content.