I added TintAndShade
and PatternTintAndShade
to an Excel 2007 vba macro. A colleague tried them out in Excel 2003 and found that those commands did not work there.
How can I then convert the following code into something that will work in Excel 2003?
With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 5296274 .TintAndShade = 0 .PatternTintAndShade = 0 End With
where the lines that need conversion are:
.TintAndShade = 0 .PatternTintAndShade = 0
Note: I use this for changing cell properties.