I would like slightly rounded corners on some excel tables, and can't seem to
find information on whether this is even possible. Any help is appreciated.

You could use the drawing toolbar and select rounded rectangle from auto
shapesbasic shapes.

Draw a rectangle around the table then.

Format it to "no color".

This macro does this with any range selection.

Sub RoundRectangle()
Dim x, y As Single, area As Range
For Each area In Selection.Areas
With area
x = .Height * 0#
y = .Width * 0#
ActiveSheet.Rectangles.Add Top:=.Top - x, Left:=.Left - y, _
Height:=.Height + 1 * x, Width:=.Width + 1 * y
End With
With ActiveSheet.Rectangles(ActiveSheet.Rectangles.Coun t)
.Interior.ColorIndex = xlNone
.ShapeRange.AutoShapeType = msoShapeRoundedRectangle
End With
Next area
End Sub


Gord Dibben MS Excel MVP

On Mon, 2 Jul 2007 09:24:00 -0700, BrandonG
wrote:

I would like slightly rounded corners on some excel tables, and can't seem to
find information on whether this is even possible. Any help is appreciated.