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