Dear Expert.

I having an issue for Countif function. Below code showed out of range.
If WorksheetFunction.CountIf(Workbooks("Dean-Temp-PC2.xlsm").Worksheets("Datas").Range("A:A"), Mid(TextBox2.Text, 1, 8)) > 0 Then
The file in was saved in same folder. Any idea?

Thank you