I am comparing values in cells of two work sheets. The sheets are supposed to contain the same values.
If a cell in one sheet does not correspond to the cell in the other sheet, then the program displays the unequal cells and stops.
If cell a1 in sheet1 has a value of 0 (zero) and cell a1 in sheet2 is blank, the following statement evaluates as false:
If (Worksheets("Sheet1").Cells(X, Y).Value <> Worksheets("Sheet2").Cells(X, Y).Value) Then
In other words, the statements after "Then" are skipped and the program checks the next pair of cells.
How can I get VB to realize 0 and blank are <>??