Border

  • Thread starter Thread starter Maximus
  • Start date Start date
M

Maximus

I am trying to create a border around a selection. I am currently
using

Range("C23:G27").Select
Selection.Borders.LineStyle = xlDouble

This results in borders throughtout every cell. How do I get a border
around the perimeter?

Thanks
 
Range("C23 :G27").BorderAround LineStyle:=xlContinuous,
weight:=xlThick
HTH Otto
 
Range("C23:G27").BorderAround LineStyle:=xlDouble

There's more options for .borderaround that you may want to read about in VBA's
help.
 
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

Problem setting BorderArround LineStyle:=xlLineStyleNone 3
VBA set thick borders around non empty cells in range 0
"Unable to set the LineStyle property of the border class" 4
Code debug 5
use border for IF test 1
Border formatting row of cells 22
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 7
Do I need these lines? 5

Back
Top