VBA delete rows

[galmond1010]

I have an Oracle report that is converted to delimited text. I need to delete the entire row if column A is blank. I need the VBA to start on row 30. Does anyone have a VBA code for this?
Thank you.

 

[Fluff]

How about

Range("A30:A" & Rows.Count).SpecialCells(xlBlanks).EntireRow.Delete

 

[galmond1010]

Beautiful. One last favor. I also need to delete rows that contain the work "of" in column F. I am attempting to clean up data that show the pages (i.e. 3 of 242, 4 of 242, etc). Thank you in advance.

 

[Fluff]

Use Autofilter to filter for rows with "of" & then delete them.
You can use the macro recorder to get the code.

 

[galmond1010]

Can do. Thank you.

 

[Fluff]

You're welcome.
Any problems, just post back