Delete a row that the active cell is in

Posted by John Gun on February 11, 2002 5:20 PM

How can a write a macro that will goto a specified cell (specified by the user) and then delete that row.

Thanks very much
John

Posted by Derek on February 11, 2002 8:35 PM

If your user enters a cell address (eg D5 or D5:D7) in A1, this macro code, when run, will delete those rows

Range(Range("A1").Value).EntireRow.Delete

Hope this helps