Hello all,
I am trying to write an excel function to get the color index (according to column 2 of this chart: color indexes in excel) for all cells in column 1. I tried:
Function NumColor()
NumCouleur = Cells(1, Row).Font.ColorIndex
End Function
I get the error message "NumCouleur is empty".
Thanks for any help!
André
I am trying to write an excel function to get the color index (according to column 2 of this chart: color indexes in excel) for all cells in column 1. I tried:
Function NumColor()
NumCouleur = Cells(1, Row).Font.ColorIndex
End Function
I get the error message "NumCouleur is empty".
Thanks for any help!
André