> This test case seems to test the wrong thing, indeed.
`Application.Worksheets` basically resolves to `Application.ActiveWorkbook.Worksheets`, which is not the same as `ThisWorkbook.Worksheets`, in general. Using the the code name yields the same result as the latter. The active workbook might be an entirely different workbook to which there is no reference on compile time.