Cell Wrap - Revision history

imported>Bob at 20:29, 12 March 2008

2008-03-12T20:29:34Z

imported>Bob at 20:27, 12 March 2008

2008-03-12T20:27:43Z

imported>Bob at 19:33, 12 March 2008

2008-03-12T19:33:37Z

New page

Copy and paste the text in the box into the visual basic editor that comes with Excel. To get access to personal.xls in the visual basic editor check out this article: [[Save_Macros_in_Excel]]

This short macro does a cell reformat making the cell text do a word wrap within the cell so you can see it all. Useful for long column headers when you're working with time series data such as met or soil climate data.

option explicit
Sub Cell_Wrap()
' This shorty macro does the wrap text f(x) for cells so you can
' see what's in cells with lots of text.
'
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
End Sub

@@ Line 1: / Line 1: @@
 Copy and paste the text in the box into the visual basic editor that comes with Excel.  To get access to personal.xls in the visual basic editor check out this article: [[Save Macros in Excel]]
-This short macro does a cell reformat making the cell text do a word wrap within the cell so you can see it all.  Useful for long column headers when you're working with time series data such as met or soil climate data.  Once you've added this macro to your library you may also find it useful to create a [[tool bar button|menu button]] for it
+This short macro does a cell reformat making the cell text do a word wrap within the cell so you can see it all.  Useful for long column headers when you're working with time series data such as met or soil climate data.  Once you've added this macro to your library you may also find it useful to create a [[Tool Bar Button|menu button]] for it.
   option explicit