I have made this simple code which replaces an empty cell with "Empty" on a button.
But when I run it I get the error message "End IF without Block IF"Sub Button1_Click() If Range("A1") = "" Then Range("A1") = "Empty" End If End Sub
Spreadsheet attached.
Can anyone understand why - Can anyone help?
Bookmarks