alexnkc
11-26-2013, 07:02 PM
Hi,
I will like to ensure that cell A1:A9 and C1 is filled before proceed to another VBA language.
Please help on the VBA language as it is not working.
If Sheets("Sheet1").Range("A1:A9").Value = "" Then
MsgBox Title:="Warning", Prompt:="Please fill-up the Empty Cell in-order to proceed"
Exit Sub
End If
If Sheets("Sheet1").Range("C1").Value = "" Then
MsgBox Title:="Warning", Prompt:="Please fill-up the Empty Cell in-order to proceed"
Exit Sub
End If
Thanks
I will like to ensure that cell A1:A9 and C1 is filled before proceed to another VBA language.
Please help on the VBA language as it is not working.
If Sheets("Sheet1").Range("A1:A9").Value = "" Then
MsgBox Title:="Warning", Prompt:="Please fill-up the Empty Cell in-order to proceed"
Exit Sub
End If
If Sheets("Sheet1").Range("C1").Value = "" Then
MsgBox Title:="Warning", Prompt:="Please fill-up the Empty Cell in-order to proceed"
Exit Sub
End If
Thanks