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

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

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

Sorry for duplicate response, but it worked on my friend's computer, with
Excel 2003... so, it's not a version problem...

thanks!

"Jair Batista" wrote:

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

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

You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.



Posted as a reply to:

Problem with .TintAndShade

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

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx

had the same problem the other way round- when using a macro created with excel 2003 in excel 97.

I decided to just exclude the tintandshades from the code, because it had no effect in 97 anyway and the macro worked out afterwards.

I experienced the same problem with ThemeFont

' .TintAndShade = 0
' .ThemeFont = xlThemeFontNone





Posted as a reply to:

tintandshade

You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx