Excel Text Orientation

[Codehammer]

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.

[Static]

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:

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:

Range("E13").Orientation = 90

[Static]

oh.. and alignment:

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

[Codehammer]

Your Tips Better Than Getting The Ebook!!

[Static]

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

[Codehammer]

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,

[Static]

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?

[Codehammer]

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?