Simple code to clear cell if another cell has no value

[ipbr21054]

Evening,
Red arrow column H
Blue Arrow column J
Green arrow column M

For your information column M has the following code then down the page to row 36

=IF(AND(H27="",J27=""),"",H27*J27)

Im trying to clear the text in column / cells J if no value is in column / cells H

Example.
Currenly cell H27 has a value of 1 & cell J27 has a value of £10.00
If i delete the 1 in cell H27 i require the value in cell J27 to be deleted so the cell is empty.

I tried the following down to row 36 but nothinh happened when the Hcell value was removed

If Range("H27").Value = "" Then Range("J27").Value = ""
If Range("H28").Value = "" Then Range("J28").Value = ""
If Range("H29").Value = "" Then Range("J29").Value = ""

 

[rlv01]

If the cell is not empty, then there is something in it. You could change some code to investigate what happens when you delete the cell.

    If Range("H27").Value = "" Then
        Range("J27").Value = ""
    Else
        MsgBox "H27 Ascii code: " & Asc(Left(Range("H27").Value, 1)), , "Cell not empty"
    End If

Issues I've seen are that the cell has space characters or sometimes the null char (ascii 160) that make you think the cell has no value when it does.