I didn't see any reply to this Addam, but have you tried BorderAround?
MS help files say:
expression.BorderAround(LineStyle, Weight, ColorIndex, Color)
This bit puts a solid, thick, blue border around a selection of cells - not within.
selection.borderaround 1,xlthick, 5
I hope this works for
VB.Net
Regards
Robert McCurdy
"Addam" wrote in message ...
Anyone,
I am trying to add and bold a border around a cell in Excel. I do not
know how to do this in code. Basically a cell has 4 sides. In
vb .net 2003
I want to select the sides. Top, Bottom, left, or right, then I want to add
a solid line bold boarder. the result would be something like this: Assume
top and bottom are always there
| 3 cells | 5 cells | 1 cell |
|___|_____|_|
does anyone know how to do this?
~thanks
addam