Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell color in different workbook
I need to programmatically reference a cell in a different workbook
(Excel file). Once I reference that cell, I need to determine the color and then change a cell in my current workbook to that exact color. Example: C:\ExcelFile1.xls Column C Row 33 Color is Blue H:\Project\MasterPlan.xls Column H Row 40 Color needs to be Blue as it is in above workbook\cell. Any thoughts? THANKS Tammy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell color in different workbook
Will the workbooks be open? Assuming so
Workbooks("MasterPlan.xls").Worksheets("Sheet1").R ange("H40").Interior.Color index = _ Workbooks("ExcelFile.xls").Worksheets("Sheet1").Ra nge("C33").Interior.Colori ndex -- HTH RP (remove nothere from the email address if mailing direct) "FireGeek822" wrote in message oups.com... I need to programmatically reference a cell in a different workbook (Excel file). Once I reference that cell, I need to determine the color and then change a cell in my current workbook to that exact color. Example: C:\ExcelFile1.xls Column C Row 33 Color is Blue H:\Project\MasterPlan.xls Column H Row 40 Color needs to be Blue as it is in above workbook\cell. Any thoughts? THANKS Tammy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing a cell color in different workbook
Thanks Bob. My first try with this I used RGB( ) and didn't realize
the color index is a long number and doesn't use the traditional RGB numbers. Now I need to try to restrict all users of both workbooks to use only 6 specific colors. I appreciate the help Bob, Thanks Again!!! Tammy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using names referencing a cell in another workbook | Excel Worksheet Functions | |||
Referencing a cell in another worksheet within the same workbook | Excel Worksheet Functions | |||
Referencing a cell in another worksheet within the same workbook | Excel Worksheet Functions | |||
variations on referencing a cell in another workbook | Excel Discussion (Misc queries) | |||
referencing a cell in a workbook on the web. | Excel Programming |