Forum Discussion

Ronald_Hoerner's avatar
Ronald_Hoerner
Copper Contributor
Jan 28, 2023
Solved

cell format info in formulas

I wrote a small routine to count the number of cell in a range (calendar_ronald)  that match the color of a cell (cell_color).   Sub CountCellsByColor() Dim calendar_ronald As Range Dim cell_colo...
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Jan 29, 2023
    No. Function can't work with color.
Harun24HR's avatar
Harun24HR
Silver Contributor
Jan 28, 2023

Ronald_Hoerner To get count result in cell replace below line-

MsgBox "The number of cells in the given area with the specified color is: " & color_count

With

Range("F1") = color_count
Ronald_Hoerner's avatar
Ronald_Hoerner
Copper Contributor
Jan 29, 2023

Thanks Harun24HR 

 

Is it also possible to do this with a function instead of a macro?

  • Harun24HR's avatar
    Harun24HR
    Silver Contributor
    Jan 29, 2023
    No. Function can't work with color.