Interior Color No Fill
Then another procedure must run.
Interior color no fill. You can use colorindex to find a cell with no fill color and if colorindex does not indicate it s got no fill use color to get the actual color. Activecell interior colorindex 4105 in another macro i check the the color of the cell and if it has no fill. The color of the tab.
The problem is that it puts white and the borders disappear. I m opening the excel and after i m setting the color of the first cell to transparent like this. I ve also tried this.
This property specifies a color as an index into the color palette. Hi windows xp excel 2003 im having huge trubles with the interior color for the cells. Set colorindex to xlcolorindexnone to specify that you don t want an interior fill.
For that purpose i use the line. I have a macro that removes the color of a cell no fill. The cell shading color or the drawing object fill color.
I want to put the no fill option and it s not working. This example sets the color of the tick mark labels on the value axis on chart1. Hey guys you can use this for selecting no fill option thisworkbook sheets 1 interior color xlnone otherwise if you want to set any background color you can use this way thisworkbook sheets 1 interior color vbgreen.