ByRef Argument Error With Worksheet Exists Code

I am using this function to determine whether a worksheet exists in a workbook.

Please Login or Register  to view this content.

I call the function with this code ...

Please Login or Register  to view this content.

The worksheet (WSName) should exist in a second open workbook (wb_pstaff), but I'm getting an error in the calling code highlighted in red. ("ByRef Argument type mismatch").

Can anyone advise what I need to do to get things working properly?

The variables must be the same data types when ByRef , so either
in your sub

Please Login or Register  to view this content.

or function

Please Login or Register  to view this content.

Thank you both! :-)

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.