What's the VB Code to set the background color and borders for a cell? Thanks p
K k483 Nov 1, 2004 #1 What's the VB Code to set the background color and borders for a cell? Thanks p
R Ron de Bruin Nov 1, 2004 #2 Hi K483 Use your macro recorder to record the code With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With
Hi K483 Use your macro recorder to record the code With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With