Re: Excel Text Orientation
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
Re: Excel Text Orientation
oh.. and alignment:
Worksheets("Sheet1").Range("A1").HorizontalAlignment = xlRight
Worksheets("Sheet1").Range("A1").HorizontalAlignment = xlCenter
Worksheets("Sheet1").Range("A1").HorizontalAlignment = xlLeft
Re: Excel Text Orientation
Your Tips Better Than Getting The Ebook!!
Re: Excel Text Orientation
Tips and information here, with the years of combined knowledge of the members.. better than ANY book ;)
Re: Excel Text Orientation
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,
Re: Excel Text Orientation
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?
Re: Excel Text Orientation
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?