Blank cell stops Marco

Birdy92 · Apr 16th, 2002, 11:01 AM

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 · Apr 16th, 2002, 11:10 AM

Try the following:

Code:

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.

Apr 16th, 2002, 11:10 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: Code: 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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 11:01 AM	#1
Birdy92 New Member Join Date: Apr 2002 Posts: 14	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