RE: Ending a macro early conditionally on one cell being blank

Giganews Newsgroups
Subject: RE: Ending a macro early conditionally on one cell being blank
Posted by:  Gary''s Student
Date: Fri, 26 May 2006

Sub Macro1()
If IsEmpty(Range("Q2").Value) Then
Exit Sub
End If
End Sub

--
Gary''s Student

"Rokuro kubi" wrote:

> How do I get the macro to end itself once all the data has been taken
> elsewhere?
>
> If IsEmpty("Q2") Then Exit Sub?
> Else 'do nothing - it's still got data I want it to continue the macro
> End If? 'here there is an error message of "End If without Block If"

Replies

In response to

Ending a macro early conditionally on one cell being blank posted by Rokuro kubi on 26 May 2006