grid lines covered up

[John A Grandy]

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.

 

[Patrick Molloy]

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