VBA: empty cell, no formula

[jamescooper]

Hello this code executes and does what I want to if there is text in the cell. It is still doing it if the cell is empty and there is a formula in there.

Any ideas how to adapt it so that is ONLY executes when the cell is empty?

       If Not IsEmpty(Cells(ToRow, "E")) Then

Thanks.

 

[Joe4]

Try this instead:

If Cells(ToRow, "E") <> "" Then

 

[jamescooper]

Try this instead:

If Cells(ToRow, "E") <> "" Then

Works great thanks!

 

[Joe4]

You are welcome!