View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wen[_2_] Wen[_2_] is offline
external usenet poster
 
Posts: 3
Default delete rows in a given range

Anyone has a good sub to delete from a given range any row with blank index
cell?
For example, I have a table range with column A titled "Name" as index
column. I need a sub that deletes any row where column A is blank, but say,
column C has non-blank value. it is not the same as deleting all blank rows
in a range.
TIA.
Wen