View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree23[_3_] scrabtree23[_3_] is offline
external usenet poster
 
Posts: 55
Default Delete Certain Rows

I would like a VBA code to delete certain rows on a sheet.

If I use xldown it will go to the last row of data in a table. There is
more data on the sheet below this but there is a line that is skipped between
the target table and the additional data. So, I want to select cell A:1,
then do an xldown to get to the last row in the target table. I then want to
delete row 3:3 through the desired last row.

How?

Thanks