check for worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I check to see if a worksheet already exists before creating it using
VBA?
 
I stole this from Chip Pearson:

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

'and you can use it like:
....
if worksheetexists("myname",activeworkbook) then
 
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

Excel VBA 0
Conditional Sum across WORKSHEET 6
Worksheet Names using Macros 5
Cell Referencing 5
Copy a range data from 1 sheet to multiple selected sheets 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Worksheet Tab Name from Cell C4 5
How do I add NOT insert additional worksheet to existing workbook. 6

Back
Top