Hi I need help, I need a VBA that any cell in Column "E" that starts with “https:*” becomes an Active Hyperlink and displays as “Link to Site” and all cells do not become Hyperlinks and are unchanged.
I have tried a few methods (one below) but all convert all cells in E Column to Hyperlinks...