| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resetting the background color of a cell?
I'm sure this is an easy one, but...
I have a VBA macro that rolls over a bunch of rows and colors cells that I think might be bad, either yellow or red depending on the error. The user then fixes the problems and runs again. Thus I want to clear out any color that might be there, because it's likely been fixed. So I did... Cells(lineno, 12).Interior.Color = vbWhite But this also makes the cell borders disappear! They are set to "automatic" in the format dialog. What am I doing wrong? Maury |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Resetting the background color of a cell?
Cells(lineno, 12).Interior.ColorIndex = xlNone
-- Regards, Tom Ogilvy "Maury Markowitz" wrote: I'm sure this is an easy one, but... I have a VBA macro that rolls over a bunch of rows and colors cells that I think might be bad, either yellow or red depending on the error. The user then fixes the problems and runs again. Thus I want to clear out any color that might be there, because it's likely been fixed. So I did... Cells(lineno, 12).Interior.Color = vbWhite But this also makes the cell borders disappear! They are set to "automatic" in the format dialog. What am I doing wrong? Maury |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Resetting the background color of a cell?
Cells(lineno, 12).Interior.ColorIndex = xlNone
Thanks. Is the trick here the "index"? Maury |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Resetting the background color of a cell?
Excel only supports 56 colors in a worksheet. So using ColorIndex can be
very straighforward. Once using colorindex, then the trick is using xlNone. -- Regards, Tom Ogilvy "Maury Markowitz" wrote in message ... Cells(lineno, 12).Interior.ColorIndex = xlNone Thanks. Is the trick here the "index"? Maury |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell background color and cell text color | Excel Worksheet Functions | |||
| Cell background color (interior color) setting not working | Excel Programming | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
| Set background color of a cell in VBA | Excel Programming | |||
| Color of Cell Background | Excel Programming | |||
Linear Mode
