grid lines covered up
 

i've brought this up before ... just want to see if anyone has some fresh
input ......

The problem stems from the fact Excel paints the grid before it fills the
background color of any ranges for which

Range.Interior.ColorIndex < xlColorIndexNone

So, filling a range with a color overwrites the grid-lines for the cells in
that range.

Given that it is quite common to want to hi-lite rows, or columns, of a
sheet in various ways .....

I am thinking that someone out there has perfected some code to quickly
ensure that a replica of the grid is written over those ranges whose
interior fills have covered up the original grid .... ?

Thanks.

grid lines covered up
 

With Conditional Formatting one sets the cells borders,
which can also be done in code.
Use nmacro-recorder to get a feel for the code.

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
i've brought this up before ... just want to see if
anyone has some fresh
input ......

The problem stems from the fact Excel paints the grid
before it fills the
background color of any ranges for which

Range.Interior.ColorIndex < xlColorIndexNone

So, filling a range with a color overwrites the grid-
lines for the cells in
that range.

Given that it is quite common to want to hi-lite rows,
or columns, of a
sheet in various ways .....

I am thinking that someone out there has perfected some
code to quickly
ensure that a replica of the grid is written over those
ranges whose
interior fills have covered up the original grid .... ?

Thanks.


.