ISBLANK

viper · May 18th, 2002, 11:19 AM

What would be the proper way to write code to check for all blank cells in Range(A9:A130) and then delete those rows that are blank?

I've tried using:
if(isblank(Range(A9:a130)) then
cells.entirerow.delete

but it wouldn't work.

thanks,

_________________
Soon I hope to be answering alot of these questions instead of asking them.

viper

[ This Message was edited by: viper on 2002-05-18 10:20 ]

dk · May 18th, 2002, 11:58 AM

Hello Viper,

This single line of code should do what you want:-

Range("A9:A130").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

HTH,
Dan

Nimrod · May 18th, 2002, 12:18 PM

WOW !!!!

I'll remember that one ..Thanks

viper · May 18th, 2002, 12:36 PM

Excellent dk.

Thank you so much.

Worked perfectly.

May 18th, 2002, 12:36 PM	#4
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	Excellent dk. Thank you so much. Worked perfectly. __________________ I appreciate the help from everyone at Mr. Excel. viper

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

May 18th, 2002, 11:19 AM	#1
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	What would be the proper way to write code to check for all blank cells in Range(A9:A130) and then delete those rows that are blank? I've tried using: if(isblank(Range(A9:a130)) then cells.entirerow.delete but it wouldn't work. thanks, _________________ Soon I hope to be answering alot of these questions instead of asking them. viper [ This Message was edited by: viper on 2002-05-18 10:20 ]

May 18th, 2002, 11:58 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hello Viper, This single line of code should do what you want:- Range("A9:A130").SpecialCells(xlCellTypeBlanks).EntireRow.Delete HTH, Dan

May 18th, 2002, 12:18 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	WOW !!!! I'll remember that one ..Thanks