With ActiveCell properties

[mrsushi]

Trying to figure how to amend the formula as per below

Cell A12 is blank as per below VBA formula.
Cell B12 is blank too.

So when the formula in C12 is as follows A12=B12, this produces a FALSE. How is this when both A12 B12 Is blank?

How can I amend the formula so that both cell empty values equates to TRUE?


With ActiveCell.Offset(12, 0)
.Value = " "
End With

Many thanks

 

[Fluff]

How is this when both A12 B12 Is blank?

One of them isn't empty, your code is putting a space into a cell, therefore it isn't empty.
Also with your code, if A1 is the active cell, then it's putting the space into A13 not A12

 

[mrsushi]

how do we alter the code to remove the space?

like below?

.Value = ""

 

[Fluff]

That's right.