deleting rows

Mar 7th, 2002, 05:57 PM

guys, how can I create a macro to delete a group of rows within a range (ie- C30 thru C55) if any of the cells in this range (C30-C55) are empty, leaving just those rows in that range that have text entries? Thanx!

Juan Pablo González · Mar 7th, 2002, 08:49 PM

Is this what you want ?

Range("C30:C55").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

Mar 8th, 2002, 10:40 AM

It is probably what I want, but I am not exactly sure where to put this code (module, sheet, etc.) And is there anything else I need to add before/after the code? Thanks again!

Mar 7th, 2002, 08:49 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,758	Is this what you want ? Range("C30:C55").SpecialCells(xlCellTypeBlanks).EntireRow.Delete __________________ 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

Mar 7th, 2002, 05:57 PM	#1
Guest Posts: n/a	guys, how can I create a macro to delete a group of rows within a range (ie- C30 thru C55) if any of the cells in this range (C30-C55) are empty, leaving just those rows in that range that have text entries? Thanx!

Mar 8th, 2002, 10:40 AM	#3
Guest Posts: n/a	It is probably what I want, but I am not exactly sure where to put this code (module, sheet, etc.) And is there anything else I need to add before/after the code? Thanks again!