Empty cell without "Clear contents"

[bobkap]

If a cell is cleared by just hitting the spacebar I understand that it is not really "clear" unless you clear it with "Clear Contents".

Is there a way in VBA that you are able to show a cell as clear when it has been cleared by just using the spacebar?

For example, in the code below, cells (4,2) will not show as empty unless they have been emptied by using Clear Contents.

If IsEmpty(Cells(4, 2)) Then
cost = Price * (1 - margin)
Cells(4, 2) = cost

 

[Snakehips]

@bobkap Maybe try like below.

If Len(Trim(cells(4,2)))= 0 Then

 

[bobkap]

@bobkap Maybe try like below.

If Len(Trim(cells(4,2)))= 0 Then

Worked like a charm!! Thanks very much!