|Subject:||RE: Ending a macro early conditionally on one cell being blank|
|Posted by:||Kevin B|
|Date:||Fri, 26 May 2006|
How about trying:
If Range("Q2").value = "" then Exit Sub
"Rokuro kubi" wrote:
> How do I get the macro to end itself once all the data has been taken
> 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"
Ending a macro early conditionally on one cell being blank posted by Rokuro kubi on 26 May 2006