I have what seems to me to be identical code trying to look at a cell value.
When I'm running my macro in single step debug mode and hover my cursor over this command:
If Range("S" & I) = "New Membership Required" Then
It displays the true value in the appropriate row in column "S" ** I is in for/next loop. This code works as intended.
But I have another piece of code in the same for/next loop that doesn't show the value when I hover the cursor and also doesn't work properly:
If Range("D" & I) <> "" Then
I visually see that the cell value does not = "" but the code skips instructions following the "Then".
Both column S and column D are defined as "General".
Thanks for any assistance.
Bookmarks