Setting background color with VBA removes gridlines -- how to bring back

**chasdl** · 02-09-2013, 02:32 PM

Hi Folks,

Glad you guys are here and thanks so much for any help.... I'm using Excel 2010 on a Windows XP SP3 system.

I've discovered that using VBA to set the background color on a range of cells in a worksheet also wipes out the gridlines. My questions are two fold. First, how can I bring those gridlines back once they have been wiped out? I notice that the global "Gridlines" option has no effect on the range that has been cleared through VBA. And second, is there any way to use VBA to change the color of a cell in a way that does not affect the gridlines? I need the ability to mark certain cells through VBA in a way that preserves the gridlines.

Thanks, and best to all....

**shg** · 02-09-2013, 02:34 PM

Gridlines only appear when cells have no fill, so no. The fill doesn't remove them, it covers them.

You can use borders.

**chasdl** · 02-10-2013, 05:01 PM

Thanks for the response... That actually answered one of my questions but raised another. Since you mentioned that the background color only covers the gridlines, I was able to make them come back visually by setting the color index to xlColorIndexNone. Worked fine, and I know how to handle that problem in the future.

However, I am unfamiliar with using borders in VBA... Can you elucidate a little on that? For example, how do we set or remove borders from a cell using VBA?

Thanks...