View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Delete non-contiguous selected rows

Why not use

Selection.EntireRow.Delete



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Barbara Ryan" wrote in message news:2B48g.9444$B42.2788@dukeread05...
I need to be able to delete rows (via VBA) that a user selects on a
worksheet. The rows can be non-contiguous. I have seen several examples to
delete non-contiguous rows based on a cell value, but not for non-contiguous
selected rows. Any suggestions???

Thanks,
Barb Ryan