| 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 |
| 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 | |||
Threaded Mode
