ExcelBanter - Macro to delete a row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro to delete a row (https://www.excelbanter.com/excel-discussion-misc-queries/43391-macro-delete-row.html)

kiran

Macro to delete a row

Hi All
Can any one tell me how to write a macro to delete a row

Rowan

A few ways:

Rows(1).Delete
ActiveCell.EntireRow.Delete
Range("A1").EntireRow.Delete

Regards
Rowan

"kiran" wrote:

Hi All
Can any one tell me how to write a macro to delete a row

All times are GMT +1. The time now is 08:28 PM.