Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Quick VBA Worksheet Change Event or Selection Question: | Excel Worksheet Functions | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple selection, but hey, I'm no guru!! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple Selection Macro | Excel Programming |