Problem with .TintAndShade

[Jair Batista]

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

 

[Spreadsheet Solutions]

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

 

[Jair Batista]

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

Thanks!

 

[Jair Batista]

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

thanks!

 

[Chip Pearson]

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)

 

[hattiflatti]

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 = xlContinuou
.ColorIndex =
.TintAndShade =
.Weight = xlThi
End Wit

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/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx

 

[hattiflatti]

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/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx