Remove Duplicates and its associated Hyperlinks if present

[BlackEagle711]

Hi all,

I'm a newbie and need help.

I have Excel 10. I have a spreadsheet containing a single Column (A) which contains a list of URLs which have hyperlinks associated with each URL, of which there are a lot of duplicates. Say Range (A1:A25). 15 of the 25 are duplicates, thus 15 duplicate hyperlinks

I attempted to use the Excel built in "Remove Duplicates". It removed the duplicate Text but not the URL Hyperlinks within the cells. I want to Keep the unique URLs and its associated Hyperlinks and Remove the duplicate URLs an its associated Hyperlinks.

Can this be resolved using VBA. If so, how.

Any assistance is appreciated.

Thanks,

BlackEagle711

 

[hiker95]

BlackEagle711,

Welcome to the MrExcel forum.

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.