Thread: worked yesterday- doesn't work today
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Chip[_3_] Chip[_3_] is offline
external usenet poster
  
Posts: 133
Default worked yesterday- doesn't work today
I was stupid...change the "End Sub" in the If Statement to "Exit Sub":

If IsEmpty(Sheets(1).Range("B4")) Then
MsgBox("Name Not Defined")
Exit Sub
End If

Reply With QuoteReply With Quote