Delete rows

[jumbla]

I have an excel worksheet with two different tables. In the second table I want to delete some rows that are showing. If some rows in (range) A50:A150 is blank then all cells in P50:P150, with the same row, should be deleted.

I tried this

On Error Resume Next
Range("A50" & lr).SpecialCells(xlCellTypeBlanks).EntireRow.Delete

it removed everything above and under A50 that had empty rows.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[TMS]

Think it should maybe be:

Please Login or Register  to view this content.

Regards, TMS



Please note ...

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here