View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John A Grandy John A Grandy is offline
external usenet poster
 
Posts: 22
Default 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.