Border Thickness

[robertw477]

Is there a way to control the border thickness on a worksheet. In the border dialog box I see no mention of thickness of the border. I am using excel 2007. I see various examples of dashed lines etc but what if I just want a thickness that is half the default thickness?

Thanks
Rob

 

[Lewiy]

As far as I know (using xl2003) there are only 4 different weights of border you can apply to a cell: Hairline, Thin, Medium and Thick.
You can apply these weights via VBA:

Range(“A1”).BorderAround(Weight:= xlHairline)