macro stops if no empty cells are found

Feb 27th, 2002, 08:22 AM

I used the macro recorder to automate a task performed daily. In column C, it looks for blank cells and is supposed to delete the entire row if C has a blank cell. If there are no blank cells, the macro stops and I get a run-time error, and it says no cells were found. How do I make it just continue of there are no blank cells in column C?

Thanks!

Juan Pablo González · Feb 27th, 2002, 08:23 AM

Put

On Error Resume Next

before looking for blank rows.

Feb 27th, 2002, 08:23 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Put On Error Resume Next before looking for blank rows. __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Feb 27th, 2002, 08:22 AM	#1
Guest Posts: n/a	I used the macro recorder to automate a task performed daily. In column C, it looks for blank cells and is supposed to delete the entire row if C has a blank cell. If there are no blank cells, the macro stops and I get a run-time error, and it says no cells were found. How do I make it just continue of there are no blank cells in column C? Thanks!