VBA to Check if Worksheet Exists in A Workbook

[juan4412]

I have an array that opens a workbook containing close to 100 worksheets, and copies specific sheet names into there own individual workbooks. The problem I have now, is that I assume the worksheet exists in the workbook, but often times it does not Is there a way to add some sort of "catch" that will 1st verify the worksheet exists instead of my code crashing?

 

[juan4412]

Tusharm --- that will work for copying the sheets, but where in the code does it check to see if the worksheet exists?

 

[tusharm]

The WS is nothing bit.

Run the code and you will see it works correctly -- if I understood your other requirements correctly.

Tusharm --- that will work for copying the sheets, but where in the code does it check to see if the worksheet exists?

 

[juan4412]

Well, I'll be!! You were exactly right, it did execute as I was needing.

Can I throw one more stipulation into the code requirements....How would I remove highlighting (if there is any) from the worksheets in the array?

 

[Norie]

The code I posted also works, much in the same way as Tushar's does - it checks for a worksheet in a specific workbook.

I used a function because that's what was used in the code earlier.

Personally I would use the Select Case method, or something similar, to do this

I believe somebody posted the code for that earlier.

It's much shorter and more compact.