| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-defined or Object-defined-error when changing color in
I have tried the following different approaches to chaning the background
color of a cell in an Excell 2007 VBA module and have gotten Application-defined or Object-defined-error each time. I can display the color value I just can't seem to be able to change it. Sheet1.Cells(1, 2).Interior.Color = RGB(126, 255, 126) Worksheets("sheet1").Cells("A1").Interior.ColorInd ex = 3 ActiveSheet.Cells(Cell).Interior.ColorIndex = 255 Range("A1").Cells.Interior.ColorIndex = 1 Any help is welcomed. Thank you in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run Time Error 1004 Application-defined or object-defined error forsimple loop? Need help with what's wrong? | Excel Programming | |||
| Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
| Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
| Application-Defined or object defined error 1004 When ran on exel97 but not 2003 | Excel Programming | |||
| Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Threaded Mode
