Blank cell stops Marco

[Birdy92]

I am trying to set up my macro so that if say cell b5 is blank my macro will stop, and if it is possible without giving the person running the marco a notification (I already have the screen.update=false set up)

Thanks, Bill

 

[Al Chara]

Try the following:

Sub YourMacro()
For Each Cell In ActiveSheet.UsedRange
If Cell.Address = "$B" And Cell.Value = "" Then GoTo 1
Next
1 End Sub

Edit as needed, but this code will loop through all active cells until it gets to B5 and if B5 is empty.