ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Set cell text direction (degrees property?) via visual basic (https://www.excelbanter.com/excel-programming/302251-set-cell-text-direction-degrees-property-via-visual-basic.html)

James[_24_]

Set cell text direction (degrees property?) via visual basic
 
Can this be done? Cant see "degrees" as a property in the excel vb help. I
want certain cells to have the text at 90deg alignment.
Thanks
James.



Norman Jones

Set cell text direction (degrees property?) via visual basic
 
Hi James,

ActiveCell.Orientation = 45


---
Regards,
Norman



"James" wrote in message
...
Can this be done? Cant see "degrees" as a property in the excel vb help. I
want certain cells to have the text at 90deg alignment.
Thanks
James.





James[_24_]

Set cell text direction (degrees property?) via visual basic
 

"Norman Jones" wrote in message
...
Hi James,

ActiveCell.Orientation = 45



Worked a treat Norman, I'll invest in a thesaurus ;)
James.




All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com