WorksheetExists

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

My compiler doesn't recognize WorksheetExists(sheet,book). Is there a
setting in references I need to set?
 
Download from Pearson's site or:

Function WorksheetExists(SheetName As Variant, _
Optional WhichBook As Workbook) As Boolean
'from Chip Pearson
Dim WB As Workbook
Set WB = IIf(WhichBook Is Nothing, ThisWorkbook, WhichBook)
On Error Resume Next
WorksheetExists = CBool(Len(WB.Worksheets(SheetName).Name) > 0)
End Function
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro NOT completing 4
problem closing excel 1
Testing for existence of a worksheet in the active workbook 2
ms excel automation problem 2
Rename Multiple Sheets - Help with Mr Dave Peterson's Code 2
Referring to a worksheet using variable 5
Calling procedures/functions in other VBAProjects 3
Code is great, except for one thing ... 9

Back
Top