Thread: If cell empty dont run macro
View Single Post
  #3  
Old 06-18-2009, 05:27 PM
Phil_V Phil_V is offline
Valued Forum Contributor
  
Join Date: 23 Feb 2006
Location: Near London, England
MS Office Version:Office 2003
Posts: 752
Phil_V is attaining expert status Phil_V is attaining expert status
Re: If cell empty dont run macro
As the first line(s):

Code:
If Range("B5").Value = "" Then
    MsgBox "B5 is blank"
    Exit Sub
End If
__________________
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
Reply With Quote