Hi all, How do i select a worksheet based on a cells contents?, if i
have cell A1 containg a dropdown list of all the worksheets Like Week1,
Week2 etc how do i create the code to call a work sheet based on that
name instead of Worksheets("Week1").Select, so something like
Sub weekselect()
Dim t As Worksheet
t.Name = Range("f10").Value
Worksheets(t).Visible=True
Worksheets(t).Select
Worksheets("Week Selection").Visible = False
End With
End Sub

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=552518