Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Excel, grid, and pattern color
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement