If cell blank give error on update

[dan17602]

Hi All,

I have a macro that updates a worksheet based upon the value in the cell, what Im looking for is if the cell is blank to return an error saying please select.

Is this possible?

Any help would be great,

Thanks, Dan

 

[Mike Blackman]

Hi,

Do you mean like this?

    If Len(Range("A1")) = 0 Then
        MsgBox Prompt:="Please Ensure A1 has a value!", _
               Buttons:=vbCritical
    End If

 

[dan17602]

Hi Mike,

Thats great, exacly the formula I was after. However, when I put this into my existing macro it gives the error and then straight to the debug or end option. Is there a way this can stop the script if error?

Thanks again

Dan