Loop to delete rows on another tab and run until blank cell is met.

thanks Andrew! you truly are a legend!

One final thing - the spreadsheet this is working on contains product lines that have had base codes changed for various reasons and this part of the spreadsheet was to remove/delete the codes that relate to the same items but were earlier codes. Your loop works very well - but we have found that we can have 4 or more codes that relate to the 'master' code in col "A"

The data comes to us with the 'master' code in col "A" - old code 1 in "B", old code 2 in "C" and so on. How can I get this loop to run for codes in Col"B" in respect to "A" and then in col"C" in respect to "A" and so on.

Apologies if I am being stupid here - but I am new to this.

thanks for your help to date Andrew - it is HUGELY appreciated - I think by MANY MANY others on this site as well.

cheers

ps - I did try changing sSearchString from B:B to C:C thinking it was an easy answer but obviously not :-(