Hello,

I thougt I would 'try' to learn VBA.

My first attempt is to return a simple Array of ColorIndexes.
Could someone please help me with what is wrong.

Ola


Function RangeColor(Range As Range)

Application.Volatile True
Dim cell As Range

For Each cell In Range
    RangeColor = cell.Interior.colorindex
Next

End Function