Problem with .TintAndShade

  • Thread starter Thread starter Jair Batista
  • Start date Start date
J

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
 
Is it a 2007 property which doens't run (not recognized) in a 2003 version ?
 
I think you are sure... because it run on my home computer with Excel 2007,
but the problem appears in Excel 2003.

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

thanks!
 
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)
 
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
 
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
 
Back
Top