View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ivano Ivano is offline
external usenet poster
 
Posts: 28
Default delet rows based on cel content

Hi,
How can I create a macro that would delete two rows. The first row is the
one where the cell value in Column A is "L" and the second row is the row
above it.
So if A15, A20, A23 has the value (and only value) of "L" then delete it and
the row above it, which would be A14, A19, A22.

Thanks,