View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_3_] Patrick Molloy[_3_] is offline
external usenet poster
 
Posts: 27
Default 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.


.