View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Need to find two consecutive identical cells (in a column).

Tom,

Just to add a refinement.
You can skip the Edit/goto special cells, visible cells only part - it is
redundant. When you delete rows in a filter, only the visible rows are
deleted


Too true, just a bad habit from having deleted the header row too many times.

Bernie