Hi everyone! I hope everyone is safe and well.
I have a quick question, and was hoping someone could help with.
I was able to work how how to test if a particular worksheet existed within an active workbook with the following code.
Dim mySheet As String
Dim mySheetTest As String
mySheet = "Smith"
On Error Resume Next
mySheetName = Worksheets(mySheet).Name
If Err.Number = 0 Then
MsgBox "Sheet exists."
MsgBox "Sheet missing."
Would it be possible to modify this to check more than the one sheet? I need the macro to check for 5 sheets. It needs to error if any is missing (would be great to know which is missing too but not critical).
Thanks in advance!