Thread: Deleting 3 rows when current row number is unknown
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
  
Posts: 244
Default Deleting 3 rows when current row number is unknown
Try this:
Where x is the last good Row numbe
Rows(x).Offset(1).Resize(3).EntireRow.Delete Shift:=xlShiftUp
Reply With QuoteReply With Quote