Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for worksheet name
I'm new to VBA, and so my question is probably trivial to most he
I'm trying to find a sheet in workbook that best-matches the name the user enters and then activates that sheet. here's what i have so far: i get a "out of range error" when activating the desired sheet. I realize the my instr function will only give me the first instance, but my real problem is activating the desired sheet. Thanks! -Phil // ****** code below ****** Sub FindSheet() Dim sh As Worksheet 'sh is var of worksheet class Dim name As String name = InputBox(prompt:=" enter desired worksheet to find ") For Each sh In ActiveWorkbook.Sheets If InStr(UCase(sh.name), UCase(name)) 0 Then 'this is instring function Exit For End If Next sh Sheets("name").Activate 'activeworkbook is READ ONLY ' make active sheet the sought one End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search one worksheet to pull data into another worksheet | Excel Worksheet Functions | |||
Can I search for a worksheet by Tab Name? | Excel Discussion (Misc queries) | |||
Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
Search for worksheet | Excel Programming | |||
Create a search Field within a worksheet to search command buttons | Excel Programming |