"201" and 201

[Goodstart14]

Hi, I used below code, but it didn't work.
When I look the Immediate window, it says, ?ws.Range("S" & i) = wsN.Range("A" & r) = False
The Column S in ws and Column A in wsN are 'General' format.
The column S has 201, 302, 401, 502,,, and so on.
The column A in wsN has 202, 201, 401,,, and so on.
The immediate window says "201" and 201, even if it has the same 201.
I think this cause the problem.
How can I solve this?
Thanks

Please Login or Register  to view this content.

[AB33]

Change either of them in to string or value

If CStr(ws.Range("S" & i)) = wsN.Range("A" & r) Then

OR

If ws.Range("S" & i) = Val(wsN.Range("A" & r)) Then

[Goodstart14]

Thanks! It works.