VBA Error: End IF without Block IF

[Chris424]

I have made this simple code which replaces an empty cell with "Empty" on a button.

Please Login or Register  to view this content.

But when I run it I get the error message "End IF without Block IF"

Spreadsheet attached.
Can anyone understand why - Can anyone help?

[strep21]

Chris,
Use :

Please Login or Register  to view this content.

Eddie

[Chris424]

Chris,
Use :

Please Login or Register  to view this content.

Eddie

Oh my god it was that simple! Thankyou very much!

[Andy Pope]

Have a look at the help on "If...Then...Else Statement" to fully understand the difference between in line and block syntax of the IF statement.

[XiaoWei]

For a single statement of If-Then Statement, End If statement is not necessary... so it should look like this instead

Please Login or Register  to view this content.