VBA help

[Donai]

Is there a macro that will Exit sub if there is no data in Cell A2, and return msgbox "No Data"


Sub Test()

'my code

End Sub

 

[sous2817]

Something like:

Sub Test()
If Range("A2").Value = "" Then
Msgbox "No Data"
Exit Sub
Else:
{rest of code here}
End if
End Sub