Activate a Worksheet based on Variable

[kamelkid2]

I have a worksheet labeled '2008'

Please Login or Register  to view this content.

what I want to do is if a variable (SelectedYear) = 2008 then execute the code above. I know i am missing the quotations required to reference the worksheets as

Please Login or Register  to view this content.

works fine. What would be the correct syntax to do what I am looking to do? I would like to structure it this way as I have many years worth of worksheets to code for this way and I am looking to reduce the number of Sheets("n") to code

[kamelkid2]

Please Login or Register  to view this content.

The double quotations escaped the quote and functions as desired

[Norie]

2008 on it's own will be treated as the workbook index, not name.

Try this.

Please Login or Register  to view this content.