Thread: Deleting a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Deleting a row

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