View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jeff Johnson[_2_] Jeff Johnson[_2_] is offline
external usenet poster
 
Posts: 32
Default How to delete that row if same cell in preceding row is identical

"Office_Novice" wrote in message
...

ActiveCell.EntireRow.Delete Shift:=xlUp


For reference, when you delete an entire row, there's only one way to
shift....