Text Rotation

[Brian]

I''m trying to rotate text in a cell 45 degrees. Here is my code:

IRange range = _CurrentWorksheet.Range["A5:O5"];
range.CellStyle.Rotation = 45;

As soon as I hit the line of code setting the rotation to 45 degrees, I get an ArgumentOutOfRangeException:
"Specified argument was out of the range of valid values.\r\nParameter name: Indent"

Any ideas? Thanks!

[Brian]

Ah ha. I just figured it out. Apparently you cannot set it on a range of cells. If I do the cells individually it works!

[Chella Pandian B]

Thanks

With regards,
Chella