How to automatically delete certain rows in Excel?

Excel macro to delete all rows containing hyperlinks?

• I have a spreadsheet with a what seems like a million hyperlinks that I need to delete, in column B is the Part Number that the hyperlink is based off of, in colun D, and one row down is the hyperlink. Some I need all the hyperlinks and rows deleted below the part number, and two empty rows added, essentially deleting everything and leaving 2 empty rows below the project number. Any ideas on how to accomplish this?

• Answer:

  If the only data in the rows containing the hyperlinks is in a certain column, you could try filtering on that column, asking for non-blank values. That should only leave the hyperlinks. Then if you use the Go To Special, and Visible Cells Only, you should be able to add the extra rows (they'd each be after the rows with hyperlinks. Then if you again filter on the column with the hyperlinks (again, it'd only show you the rows with hyperlinks) and again use Go To Special and Visible Cells Only, you should be able to clear those row contents.