I agree that it is a version issue. I couldn't make TintAndShade work
with borders in any way on Excel 2003. The Object Browser confirms
that this is not a property of a Border object. In 2007, the code
works and the Object Browser confirms that TintAndShade is a property
of a Border object.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 8 Jan 2009 04:48:00 -0800, Jair Batista
wrote:

I have one macro with:

With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With

When i run the macro, i get the error: "Run-time error '438': Object doesn't
support this property or method". When I click "Debug", the line with
".TintAndShade" is highlighted.

Anyone can help me to solve this error?

Thanks,

Jair