What is the best way to not show any borders or gridlines around some cells
(not the whole sheet)?

For example, when I change the Layout of a Column field in a Pivot Table to
"Show Items in Outline Form," much of the Pivot Table has no black borders
and no grey gridlines around the cells.

When I use VBA to inspect those cells, I see a Borders.Linestyle = 1, and a
Borders.ColorIndex = xlColorIndexNone (-4142). So, the border seems to be a
line with no color, which must cover up the default gridlines.

But I cannot use VBA to set the borders that way. When I set the ColorIndex
to xlColorIndexNone, Excel automatically changes the Linestyle to -4142. So,
rather than getting a line with no color, I get no line (with no color).

Charlie Rowe