Cell & Font Formatting with VBA

  • 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 .. :?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!