Hi,
I have a table that stores the field name in column 1 then the colour code in column 2 (see below) in the VBA code I am trying to use the Colour code. If I use it as a number it works but I can't work out the correct number for the RGB codes I have. How do I pass the array variable?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The Array of Column 1 and Column 2 is called arrAssetClass
Range("B" & Rowcount).Interior.Color = arrAssetClass(AssetClassRow, 2)
Any ideas how I can get the correct number code or pass the RGB or Hex code?
Thanks,
Mike
I have a table that stores the field name in column 1 then the colour code in column 2 (see below) in the VBA code I am trying to use the Colour code. If I use it as a number it works but I can't work out the correct number for the RGB codes I have. How do I pass the array variable?
Column 1 | Column 2 | RGB Code |
Coxes Apples | 16225862 | 247,150,70 |
Bramley Apples | 16225862 | 247,150,70 |
Commice Pears | 1515077 | 23,30,69 |
Conference Pears | 1515077 | 23,30,69 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The Array of Column 1 and Column 2 is called arrAssetClass
Range("B" & Rowcount).Interior.Color = arrAssetClass(AssetClassRow, 2)
Any ideas how I can get the correct number code or pass the RGB or Hex code?
Thanks,
Mike