View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jair Batista Jair Batista is offline
external usenet poster
 
Posts: 5
Default Problem with .TintAndShade

I think you are sure... because it run on my home computer with Excel 2007,
but the problem appears in Excel 2003.

Thanks!

"Spreadsheet Solutions" wrote:

Is it a 2007 property which doens't run (not recognized) in a 2003 version ?

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W:
www.spreadsheetsolutions.nl
--
"Jair Batista" wrote in message
...
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