Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio 2008
Visual Studio
Visual Studio Tools for Office
Reference
2007 System Managed Reference
Microsoft.Office.Tools.Excel Namespace (2007 System)
NamedRange Class (2007 System)
NamedRange Properties (2007 System)
AddIndent Property (2007 System)
Address Property (2007 System)
AddressLocal Property (2007 System)
AllowEdit Property (2007 System)
Application Property (2007 System)
Areas Property (2007 System)
Borders Property (2007 System)
Cells Property (2007 System)
Characters Property (2007 System)
Column Property (2007 System)
Columns Property (2007 System)
ColumnWidth Property (2007 System)
Comment Property (2007 System)
Count Property (2007 System)
CountLarge Property (2007 System)
Creator Property (2007 System)
CurrentArray Property (2007 System)
CurrentRegion Property (2007 System)
Dependents Property (2007 System)
DirectDependents Property (2007 System)
DirectPrecedents Property (2007 System)
End Property (2007 System)
EntireColumn Property (2007 System)
EntireRow Property (2007 System)
Errors Property (2007 System)
Font Property (2007 System)
FormatConditions Property (2007 System)
Formula Property (2007 System)
FormulaArray Property (2007 System)
FormulaHidden Property (2007 System)
FormulaLabel Property (2007 System)
FormulaLocal Property (2007 System)
FormulaR1C1 Property (2007 System)
FormulaR1C1Local Property (2007 System)
HasArray Property (2007 System)
HasFormula Property (2007 System)
Height Property (2007 System)
Hidden Property (2007 System)
HorizontalAlignment Property (2007 System)
Hyperlinks Property (2007 System)
ID Property (2007 System)
IndentLevel Property (2007 System)
InnerObject Property (2007 System)
Interior Property (2007 System)
Item Property (2007 System)
Left Property (2007 System)
ListHeaderRows Property (2007 System)
ListObject Property (2007 System)
LocationInTable Property (2007 System)
Locked Property (2007 System)
MDX Property (2007 System)
MergeArea Property (2007 System)
MergeCells Property (2007 System)
Name Property (2007 System)
Next Property (2007 System)
NumberFormat Property (2007 System)
NumberFormatLocal Property (2007 System)
Offset Property (2007 System)
Orientation Property (2007 System)
OutlineLevel Property (2007 System)
PageBreak Property (2007 System)
Parent Property (2007 System)
Phonetic Property (2007 System)
Phonetics Property (2007 System)
PivotCell Property (2007 System)
PivotField Property (2007 System)
PivotItem Property (2007 System)
PivotTable Property (2007 System)
Precedents Property (2007 System)
PrefixCharacter Property (2007 System)
Previous Property (2007 System)
QueryTable Property (2007 System)
ReadingOrder Property (2007 System)
RefersTo Property (2007 System)
RefersToLocal Property (2007 System)
RefersToR1C1 Property (2007 System)
RefersToR1C1Local Property (2007 System)
RefersToRange Property (2007 System)
Resize Property (2007 System)
Row Property (2007 System)
RowHeight Property (2007 System)
Rows Property (2007 System)
ServerActions Property (2007 System)
ShowDetail Property (2007 System)
ShrinkToFit Property (2007 System)
SmartTags Property (2007 System)
SoundNote Property (2007 System)
Style Property (2007 System)
Summary Property (2007 System)
Text Property (2007 System)
Top Property (2007 System)
UseStandardHeight Property (2007 System)
UseStandardWidth Property (2007 System)
Validation Property (2007 System)
Value Property (2007 System)
Value2 Property (2007 System)
VerticalAlignment Property (2007 System)
Width Property (2007 System)
Worksheet Property (2007 System)
WrapText Property (2007 System)
XPath Property (2007 System)
Expand Minimize
This topic has not yet been rated - Rate this topic

NamedRange.VerticalAlignment Property (2007 System)

Visual Studio 2008

Gets or sets the vertical alignment of the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
C#
C++
JScript
VB
Copy 
[BrowsableAttribute(false)]
public Object VerticalAlignment { get; set; }

Property Value

Type: System.Object
One of the XlVAlign values.

Some of the XlVAlign values might not be available to you, depending on the language support (U.S. English, for example) that you have selected or installed.

The following code example demonstrates how to set a variety of formatting and display characteristics of a NamedRange control named NamedRange1. In particular, this example sets the VerticalAlignment property to xlVAlignCenter so that the contents of the range are centered vertically within the bounds of each cell.

This example is for a document-level customization.

C#
VB
Copy 
private void SetRangeFormats()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1", "A5"],
        "namedRange1");

    namedRange1.NoteText("This is a Formatting test", missing, missing);
    namedRange1.Value2 = "Martha";
    namedRange1.Font.Name = "Verdana";
    namedRange1.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
    namedRange1.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
    namedRange1.BorderAround(missing, Excel.XlBorderWeight.xlThick,
        Excel.XlColorIndex.xlColorIndexAutomatic, missing);
    namedRange1.AutoFormat(Excel.XlRangeAutoFormat.xlRangeAutoFormat3DEffects1,
        true, false, true, false, true, true);

    if (MessageBox.Show("Clear the formatting and notes?", "Test",
        MessageBoxButtons.YesNo) == DialogResult.Yes)
    {
        namedRange1.ClearFormats();
        namedRange1.ClearNotes();
    }
}
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.