View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
delmac delmac is offline
external usenet poster
 
Posts: 30
Default delete next cell

Hi all, I've 2 columns:about 500 rows long. I dont need the rows where column
A contains a number ending in D such as 123-D. can anyone suggest a quick way
of deleting theses. I have over 10 sheets with hundreds of items . Thanks
agin.
A B
100-C Description
123-D Description
130-D Description
500-T Description
--
delmac