I work for a large company that has set the standard font size, type and colour for certain styles.
Hyperlink is set at size 10 font, blue and underlined and obviously is a link to whatever is typed in be it a website or email address.
Because I can not change the companies template for how hyperlinks are displayed .. am I able to change it with VBA coding?
I need to alter H5:H605.
It currently displays as font size 10, Arial Font, Blue and underlined.
I need it to be font size 8, Arial, black and no underline ..
OR .. is there a way to delete hyperlink formats if a hyperlink has been entered?
HELP .. :?