Deleting a row

kirkm · Mar 10, 2009

Could someone please give a code exaple
to delete a row in Sheet1 by row number. Whether it's empty or not
and close up the gap.

Thanks - Kirk

Bob Phillips · Mar 10, 2009

Worksheets("Sheet1").Rows(97).Delete

kirkm · Mar 12, 2009

Worksheets("Sheet1").Rows(97).Delete

Thank you Bob, worked a treat.

Cheers - Kirk