Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am writting some code and i am stuck on how to select a worksheet.
There is a month listed in cell A1 of Sheet1. It is a validated cell to select months. The rest of the Sheets are labeled named with months ie. January, February ... Based on what is in cell A1 on Sheet1, I woudl like the code to select the corresponding sheet. Any guidance at all woudl be appreciated. Here is what I ahve so far and it does not work at all. Sub Tryingsomething() Dim date1 As String date1 = Sheet1.Range("A1") Worksheets(date1).Range("A1").Select End Sub Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
selecting cells in different worksheets | Excel Discussion (Misc queries) | |||
Comment BUG- selecting cells on other worksheets | Excel Discussion (Misc queries) | |||
Selecting and viewing sum in status bar across worksheets | Excel Discussion (Misc queries) | |||
Selecting and summing across worksheets | Excel Discussion (Misc queries) | |||
Selecting across worksheets | Excel Discussion (Misc queries) |