Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grid lines | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
Getting rid of grid lines | Excel Discussion (Misc queries) | |||
printing grid lines when grid lines is checked | Setting up and Configuration of Excel | |||
Grid Lines | Charts and Charting in Excel |