Color cells RGB colors, error 1004

Hello,

I try to make this code work I found on another forum.
http://www.mrexcel.com/forum/showthr...=396217&page=2
http://www.mrexcel.com/forum/showthr...=365423&page=3

I try to color Sheet1 cells D column to the color values set in Sheet2 Columns ABC
I get error 1004, see attached file. Also How can I add button to refresh the values, or to refresh them when I
open my workbook?

Sub ColorMe()
Range("Sheet1!D1:D8").Interior.Color = RGB(Range("Sheet2!A1:A8").Value, Range("Sheet2!B1:B8").Value, Range("Sheet2!C1:C8").Value)
End Sub

Thank you.

The RGB function accepts three scalar arguments, not three arrays.

Please Login or Register  to view this content.

Open the VBE, do Insert > Module, and paste the code in the window that opens.

Missed the different sheets ...

Please Login or Register  to view this content.

Thank you it certainly works OK. I have a few questions regarding usage:

1. For every range that I need I have to make new module and adjust the code?
I jsut cope the sub end sub routines and gave them different names.
2. Is it possible to add a button to update the colors
I found out it is easy just add a button and assign a macro in developer design mode.
3. Is it possible to make colors auto refresh when the workbook is opened?
You have to navigate to VBA then to open ThisWorkbook and paste this code:

Please Login or Register  to view this content.