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

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

--
__________________________________
HTH

Bob

<kirkm wrote in message ...
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

On Tue, 10 Mar 2009 09:16:03 -0000, "Bob Phillips"
wrote:

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

Thank you Bob, worked a treat.

Cheers - Kirk