Conflicting code in vba. Macro not returning proper results.

[S Oberlander]

My macro checks for the existence of two sheets usingIf Not Evaluate
The first sheet I'm checking for is returning the same result regardless if the sheet exists or not!
I tried triple checking the spelling. I tried running it from that sheet and from a different sheet... its still returning that the sheet is missing even though it actually is there.
see my code below:

Sub Check4sheets()

    If Not Evaluate("isref(Gateway report!A1)") Then      
      MsgBox "Gateway report is missing" 'I'm getting this message even when the sheet is there
    End If
    
   If Not Evaluate("isref(Pivot!A1)") Then
      MsgBox "Pivot is missing"
   End If
    
End Sub

 

[JEC]

And now? Notice the single quotes

Sub Check4sheets()
 If Not Evaluate("isref('Gateway report'!A1)") Then
    MsgBox "Gateway report is missing"
 End If
    
 If Not Evaluate("isref('Pivot'!A1)") Then
    MsgBox "Pivot is missing"
 End If
End Sub

 

[S Oberlander]

Thanks!
My guess is that the problem is the space in the sheet named gateway report

 

[JEC]

Tip:

Always use single quotations in sheetreferences. When the sheetnames do not have spaces, it will also work then