Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a sheet
I want to look though all open workbooks to see if a sheet exists. This is my
code so far: Dim SDf As Workbook, SDws As Worksheet For Each SDf In Application.Workbooks Debug.Print SDf.Name For Each SDws In Worksheets Debug.Print SDws.Name If SDws.Name = "ChemDraw1" Then Sheets("ChemDraw1").Select MsgBox ("Correct worksheet detected") Exit For End If Next SDws Next SDf From the debug.print I can tell that it only looks through the sheets in the active workbook. Can anybody help me out? The Doctor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a sheet
You need to qualify the worksheets collection with the workbook
Dim SDf As Workbook, SDws As Worksheet For Each SDf In Application.Workbooks Debug.Print SDf.Name For Each SDws In SDf.Worksheets Debug.Print SDws.Name If SDws.Name = "ChemDraw1" Then Sheets("ChemDraw1").Select MsgBox ("Correct worksheet detected") Exit For End If Next SDws Next SDf -- HTH RP "Dr.Schwartz" wrote in message ... I want to look though all open workbooks to see if a sheet exists. This is my code so far: Dim SDf As Workbook, SDws As Worksheet For Each SDf In Application.Workbooks Debug.Print SDf.Name For Each SDws In Worksheets Debug.Print SDws.Name If SDws.Name = "ChemDraw1" Then Sheets("ChemDraw1").Select MsgBox ("Correct worksheet detected") Exit For End If Next SDws Next SDf From the debug.print I can tell that it only looks through the sheets in the active workbook. Can anybody help me out? The Doctor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |