VBA To Notify if Cell is Empty

Hi,

I need VBA to give error message if certain cells are emply, I created a VBA but its not working.

Sub CALCULATE ()
If Cells(13, 8) = """" Then
MsgBox "PLEASE ENTER THE NAME"
End If

End Sub

This VBA should give Error Message if the specific cell is left blank, but its not working. Kindly rectify the error.

Rgds
ExcelMaster2012

Sir

Instead of Correcting above VBA, Can u send me a new one, I need a VBA which should notify if a cell is empty when i run the VBA. you can give an example, I will change Rowindex and ColumnIndex and use it. I will create a Button and link it. You can give default name as "Control" for that sub.

If you checking sheet1 you have to use this sub:

Sub Control()
If Sheet1.Cells(13, 8).Text = "" Then
MsgBox "PLEASE ENTER THE NAME"
End If
End Sub

Dear sir,

Many many thanks to you, it worked well.