View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
donwb donwb is offline
external usenet poster
 
Posts: 81
Default delete random rows

Excel 2003
I need some code which will delete rows containing cells I have selected.
Some cells may be adjacent then a space then more as below.
I have tried the following, but it doesn't appear work with non-adjacent
selections.
Range("D4,D5,D11,D12,D13,D14,D17,D19, D23,D24").EntireRow.Delete
How can this be done?
donwb