Hi,

I'm sure this should be simple, but I can't seem to get it to work!

I have a worksheet with over 60000 rows. There is a column which contains a product and a column offset by 2 from the product which contains the product type.

For 15 products, the product type isn't correct and needs replacing with the same product type for all 15.

I have put the 15 products into an array, thinking it would be easier to loop through the array for each find, I maybe wrong!

Problem I have is, is that I am unable to work out how to loop through all the products and change the column offset by two rather than the found cell itself! I managed it for the first product but then got stuck in a continuous loop as it kept refinding the same product!

Any help would be appreciated!

Thanks