Bharath,
You can use the BorderAround method to draw a border around a
range of cells. E.g.,
Range("C3:F5").BorderAround LineStyle:=xlSolid, Weight:=xlMedium
You can draw arrows with code like
Dim SH As Shape
Set SH = ActiveSheet.Shapes.AddLine(beginx:=Range("C3").Lef t, _
beginy:=Range("C3").Top, endx:=Range("F5").Left, _
endy:=Range("F5").Top)
SH.Line.EndArrowheadStyle = msoArrowheadTriangle
See the XRay game on my web site for lots of examples of drawing
lines on a worksheet:
http://www.cpearson.com/excel/download.htm
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Bharath" wrote in message
...
Hi,
I wanted to know if there is any programmer API to draw a
border around ranges in Excel. I basically want to demaracate
cells the way Excel does it while showing ranges involved in a
formula. Is this border functionality exposed to developers?
On the same lines, I also want to draw arrows across cells, the
way I Excel does when it shows precedents and dependents.
Any pointers will be highly appreciated.
Bharath