Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet selection
Dim wb As Workbook
Dim ws As Worksheet For Each wb In Workbooks 'Test to see if wb's name is like "ExportedData*" If wb.Name Like "ExportedData*" Then 'Create a worksheet object to reference the appropriate 'worksheet in the wb 'Why does this work... Set ws = wb.ActiveSheet 'But this doesn't? Set ws = wb.Worksheet("Tally sheet") How do I make the second one work? Once I find the specified workbook I need to select a specific sheet (Tally Sheet) in the workbook. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock worksheet, based on dropdown selection prior worksheet | New Users to Excel | |||
worksheet selection | Excel Programming | |||
worksheet selection change | Excel Programming | |||
Multiple Worksheet Selection | Excel Programming | |||
Worksheet Selection | Excel Programming |