Unable to rotate text -90 or 270

[tmayne77]

I am unable to rotate text either -90 or 270 degrees using the following code:
sheet.Range(1,8 ).Style.rotation = -90

I get the following error:
Specified argument was out of the range of valid values. Parameter name: Rotation

I can rotate the text 90 degrees just fine however.

[Jason.Tan]

Hello tmayne77,

Thank you for your inquiry.
You can use following code to set text rotation -90.

Code: Select all

sheet.Range(1,8 ).Style.rotation = 180;

180 degrees equals -90 degrees.

Best Regards

[tmayne77]

But 180 doesn't do the same as -90 or 270.