deleting rows

[Guest]

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]

Is this what you want ?

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

 

[Guest]

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!