Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |