Does not work in 2003

  • Thread starter Thread starter Microsoft Communities
  • Start date Start date
M

Microsoft Communities

The following code will not work in excel 2003, it stops on the line:
tintandshade=0
is there a work around?


Cells.Select
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
 
Don't include that line (or the line after, too!)?????

If you have to use the code in multiple versions of excel, maybe you can just
ignore the error:

With Cells.Interior
.Pattern = xlNone
on error resume next
.TintAndShade = 0
.PatternTintAndShade = 0
 
Back
Top