Macro to delete Duplicate headers after row 10 and 8 rows below this

[Howardc1001]

i have data in Col A where i want to delete the rows where these appear again after row 10 and to delete 10 below this i.e from where "Customer ID:" appears and 8 rows below this

i have tried to write code to do this, but no rows are being deleted

Please Login or Register  to view this content.

Your assistance in this regard is most appreciated

[Mumps1]

Try:

Please Login or Register  to view this content.

[maniacb]

Try changing the '=' to 'like' as below in your code

Please Login or Register  to view this content.

[Howardc1001]

Thanks very much Mumps1

How does the code supplied know that it must start from row 11 and take 8 rows below ?

[Mumps1]

The macro looks for the second occurrence of the text "Customer ID" in column A and starts deleting from that row until the last row with data.

[Howardc1001]

Thanks for the explanation Mumps1

[Howardc1001]

Thanks for the help, maniacb

[Mumps1]

My pleasure.