Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
never_cry_for_nothing
never_cry_for_nothing asked in Computers & InternetProgramming & Design · 1 decade ago

VBA excel problem, can anyone help me to write the code?

In a worksheet of A-Z listed in column A1, how do I calculate the number of red alphabets using microsoft visual basic? (red colored alphabet=D,H,K)

Thank you

1 Answer

Relevance
  • Cozmosis
    Lv 7
    1 decade ago
    Favorite Answer

    For Each Cell In Range("A1:A26")

    If Cell.Font.ColorIndex = 3 Then counter = counter + 1

    Next

Still have questions? Get your answers by asking now.