Hi, If in Excel I format a cell by changing its background color to a pattern color --
format -- Cell -- Patterns -- chose a color
Then the grid lines for that cell in the worksheet go away. How can I make these come back.
On the other hand, if I draw a box around each cell, as below, the grid outline for each
cell is much darker than the default grid lines for the spreadsheet.

thanks
Steve


*** for drawing a thin line around each cell, but too dark
.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
WITH .Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
EndWith
WITH .Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
EndWith
WITH .Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
EndWith
WITH .Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
EndWith