Hi

Hopefully someone can help.
My code searches the activesheet for a value (currency) that is in a list on a seperate sheet, it will go down the list until it has found one. Once it has found the value in the activesheet (e.g. GBP) it will delete all the cells before it leaving GBP in column A. It will then find the next GBP and delete all the cells before that.
The trouble I am having is that if GBP appears on the same row more than once it will delete all instances. How can I change the code so it only runs the code once per row and then move onto the next. 

Please Login or Register  to view this content.
Any help would be much appreciated. Thanks