View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
savbci savbci is offline
external usenet poster
 
Posts: 10
Default Deleting blank cells

i have a spreadsheet about 11 columns wide and 10,000rows down.
i want to delete all rows that have columns H, I AND J blank.
IF any one column out of the 3 are blank i do not want the row to be deleted.
The row is deleted only when the Columns H, I and J are blank in the same row.
please advise