VBA: Setting the color of borders of cells

  • Thread starter Thread starter Lazer
  • Start date Start date
L

Lazer

How do I set the inside border color of the selected sells to "gra
40%"?

Thanks,
Laze
 
Hi
try recording a macro fot this. I got the following result for this:

sub foo()
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 15
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 15
End With
end sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Border formatting row of cells 22
VBA set thick borders around non empty cells in range 0
Counting Bordered Cells 5
No borders/gridlines around some cells 2
Insert Border 2
1004 Error: Unable to set the LineStyle property of the Border class 1
Setting Colors Using Other Than ColorIndex? 2
In VBA Excel, how can I restore individual cells? 2

Back
Top