Im trying to fill 3 cells with the rgb values of the interior colour of the preceding cell, eg if cell A1 has a solid blue background then B1 would equal 0, C1=0 and D1=255. Found this code on this site;
Function FillColorRGBArray(Target As Range) As Variant
Dim N As Double, A(3) As Integer...