I am fairly conversant with excel vba. a party has sent me a file. in one of the sheets the cell B4 has the value "Client1". the macro I wrote gave me some problem.
for checking in immediate window I typed
?range("B4")="Client1" (no spelling mistake)
this gives me
FALSE
WHY????
I also tried "cellview" addin of Pearson. that gave only 7 characters and no non printing character
is the sheet or cell locked or blocked somehow??