Find values & highlighted and delete rows

Hi,

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

What is the criteria for highlighting. You have not given us enough information. We cannot read your mind and do not have crystal balls. You need to provide a clear explanation of what you wish to happen and there is no discernable data that will require highlighting. All data in column A are the same.

This worked for me'

Please Login or Register  to view this content.

sure

Please Login or Register  to view this content.

I have no idea what you mean. Please be explicit in your request. General statements such as yours are no help in providing a solution which is based upon explicit needs.

Alan,

I think I understand - when the 'search terms' in Sheet2 are changed and your macro re-run, the previously-highlighted rows stay highlighted. If Adeel chooses not to delete those rows with your second macro and then changes the search terms and re-runs the first macro, she would like the previously highlighted rows to be cleared (un-highlighted) if the search term no longer exists on Sheet2. I think a (relatively) simple select all on 'Final' sheet, set ColorIndex to none in the first macro will do it, but my VBA skills aren't good enough for me to just amend your code.