Clear contents for consecutive duplicates in selected range

**AM0305** · 01-30-2013, 07:51 PM

Hello

Trying to clear the contents of cells in range B3:N16
where there are duplicate values on consecutive rows
ie B4:N4 is the same as B3:N3 then clear B4:N4
if B5:N5 is the same then clear that also
if B6:N6 is the same then clear that too
do not want to delete/clear the surrounding area.
I found code that deletes the whole row but that does not help for this.
Any thoughts/ideas welcome
Thank You
AM

**stnkynts** · 01-30-2013, 08:15 PM

I assume you only need to compare column B not each column individually. Try:

Please Login or Register  to view this content.

**xladept** · 01-30-2013, 08:24 PM

Hi,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code into the white space on the right

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

**AM0305** · 01-30-2013, 08:26 PM

S
Thanks for the prompt response,
I should have stated more clearly.
col b c d e f g h i j k l m n all have values in them
when they are all duped in the row below then I want to clear
all but the 1sr occurence.

A B C D E F G H I J K L M N
Row 3 30 30 32 33.4 1 2 3 4 5 6 7 8 9 10
Row 4 30 30 32 33.4 1 2 3 4 5 6 7 8 9 10
Hence row 4 cleared if row 5 the same then clear also