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

    Tayler [the blue fox] :thanx:

Participate now!

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