VBA to set Cell Orientation
Posted on 2014-02-07
I am trying to set the cell orientation of the first row of my worksheet to xlUpward but I cannot get it to work, can anyone help me accomplish this?
I've tried about 30 things and nothing is working. This is what I currently have in my code.
"... all of the usual Dim objects to open the spreadsheet etc...then"
.Range("1:1").Font.Bold = True <--this works
.Orientation = xlUpward <--it breaks here