|You said: "i am now very much familiar with excel"|
Did you mean "i am not very much familiar with excel"?
I'm not sure why you want a macro when a simple process within Excel itself will give you the list of unique domains. If you are not very familiar with Excel, then consider the process below as a learning experience. Once you are familiar with the Text To Columns and Filter features, you'll be able to use them in the future.
If we simply provide a macro, you won't learn very much.
The process below looks like a lot of steps, but it actually very simple.
Let's assume your list of URLs is in Column A
1 - Select Column A
2 - Click the Data ribbon
3 - Click Text To Columns
4 - Click Next
5 - Put a / in the Other box
6 - Click Finish
You should now have a list of all Domains in Column C
7 - Select Column C
8 - On the Data ribbon, click Advanced (next to the Filter funnel)
9 - If you don't have a Column label in C1, you might get a Warning message. Just Click OK if you do.
10 - In the Advanced Filter dialog box click "Copy to another location"
11 - Enter E1 (or any other single cell reference) in the "Copy To" field
12 - Check the "Unique records only" box
13 - Click OK
In Column E you should now have a list of Unique domains.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.