| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Thanks Dave - that works a treat. Good man!
"Dave Peterson" wrote: You may want to check to make sure that the worksheet actually exists, too: Option Explicit Sub testme() Dim testWks As Worksheet Set testWks = Nothing On Error Resume Next Set testWks = Sheets(ActiveSheet.Range("H10").Value) On Error GoTo 0 If testWks Is Nothing Then MsgBox "Doesn't exist!" Else With testWks .Visible = xlSheetVisible .Select End With End If End Sub Ant wrote: Bob, I tried that code and it works perfectly. however it only works if the worksheet it is looking for is not hidden. Do you know what the additional code is to unhide and select the Sheet name in eg cell "H10". "Bob Phillips" wrote: Is the drop-down data validation? If so, it is just the cell the DV is in Sheets(Range("H10").Value).Select as an example -- HTH RP (remove nothere from the email address if mailing direct) "Ant" wrote in message ... Probably a bit of an easy one...I have a selection of hidden worksheets which appear in a drop down box and linked to a cell with a vlookup. I than have a macro button which, once clicked, opens a worksheet. I want to add some code that opens up the result of the vlookup determined by the dropdown box. For example, if I select Sheet5 from the drop down box which in turn becomes the sheet name in the vlookup cell, when I click the Macro button, Sheet5 opens. Currently I have Sheets("Sheet1").Select in the macro which obviously will only open Sheet1. I have done this before but I can't remember the code. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can the =CELL formula be used to determine the worksheet tab name. | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Worksheet Event Code | Excel Worksheet Functions | |||
Threaded Mode
