Excel Text Orientation

I am working in Excel, Its Possible to Right-Click a Cell, Format Cells, Alignment, and Enter in 90 for the Degrees to Make Text Verticle. However in the Help I Cant Find Anything on This.

Also To Center Text, The Help Has This:
Worksheets("Sheet1").Range("A1").Justify

I Replaced Justify with Center, Right, Left, But it Does Not Work.

Any Ideas, Where Can I Find a Ebook or Something on VBA thats Free.

Macros!!!

Remember, if u cant figure it out, try recording a macro of it, then look at the code
a macro of this will have a lot of extra setting which are not needed... here is the macro code:

VB Code:

Range("E13").Select
    With Selection
        .HorizontalAlignment = xlGeneral
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 90
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With

but all you need is this:

VB Code:

Range("E13").Orientation = 90

oh.. and alignment:

Worksheets("Sheet1").Range("A1").HorizontalAlignment = xlRight
Worksheets("Sheet1").Range("A1").HorizontalAlignment = xlCenter
Worksheets("Sheet1").Range("A1").HorizontalAlignment = xlLeft

Your Tips Better Than Getting The Ebook!!

Tips and information here, with the years of combined knowledge of the members.. better than ANY book ;)

Hey,

You Wrote: Range("E13"), My Question is About Ranges. I Have A Variable Stored Which First Asks The User How Many Rows He Wants Audited, Then How Many Columns.
I Need To, For A Particular Column Determine the Median. Using The =median("e23:e39") will work, But That Can Only be Done Manually in the Worksheet by the Users Themselves. If the VBA Code is to Do It, Then Something Like Worksheet("sheet1").cells(3,3).value=median(RowLimit-5,Rowlimit) Must Be Used, But It Gives A Sub Procedure not Defined Error, I Cant Check Right Now What It is Exactly, At Home Right Now.

The Help Feature Seems to Only Show Ranges Passed Through ("e33"), for The Median Function.

Anyways How Will I Overcome This? Do I Need to Work With Ranges in Terms of Absolute References ("e33:e44") or is There A Way to Get a Cell Reference in terms of ("e33:e44") by Converting the Rowlimits and ColLimits to Strings, or Do I Need to Make My Own Median Function? That Would Suck, Think of the Amount of Dynamic Arrays!!

I Also Have A Question on Circling Values if its Out Of the Specifications. Is this Possible, to Circle a Value in a Cell. I Was Thinking of Putting in a Drawing Oval, Resizing it, Removing the Fill, Then How To Place it?

Thanks for the Help,

well as far as median (which I have never used)

you should be able to do it...
say Rowlimit is 20
Worksheet("sheet1").cells(3,3).formula="=median(" & RowLimit-5 & "," & Rowlimit & ")"
something like that would put the formula in as:
"=median(15,20)"


circling a value seems like it would bee a pain.... why not just color the cell background to make it stand out?

Quote:

---

Originally Posted by Static

well as far as median (which I have never used)

circling a value seems like it would bee a pain.... why not just color the cell background to make it stand out?

---

I'll try the Tips Tonight, On Sceen Display the Figures Atand Out Red, But They Deliver the Results in B&W to the Client, Usually They Circle the Figures Manually, I Thought Consistent Formatted Circles Would Be Cool

Do You Know Anyone Who Might Know Then?