Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkSheet Present
Is there a way to check to see if a worksheet is present in a workbook?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WorkSheet Present
Dim sh as Worksheet
On error resume next set sh = Workbooks("BookA.xls").Worksheets("Sheet9") On error goto 0 if sh is nothing then msgbox "Sheet9 not in BookA.xls" else msgbox "Sheet9 was found in BookA.xls" End If -- Regards, Tom Ogilvy "Dthmtlgod" wrote in message ... Is there a way to check to see if a worksheet is present in a workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Net Present Value Question | Excel Worksheet Functions | |||
How to present a form instead of the worksheet | Excel Discussion (Misc queries) | |||
net present value | Excel Worksheet Functions | |||
Net Present Value | New Users to Excel | |||
Present Value | New Users to Excel |