Ending a macro early conditionally on one cell being blank

Giganews Newsgroups
Subject: Ending a macro early conditionally on one cell being blank
Posted by:  Rokuro kubi (rharrison-grun…@jdrf.org.uk)
Date: 26 May 2006

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