NamedRange.ColumnWidth Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the width of all columns in the NamedRange control.

public:
 property System::Object ^ ColumnWidth { System::Object ^ get(); void set(System::Object ^ value); };

public object ColumnWidth { get; set; }

member this.ColumnWidth : obj with get, set

Public Property ColumnWidth As Object

Property Value

Object

If all columns in the NamedRange control have the same width, this property returns an object that represents the width. If columns in the range have different widths, this property returns null.

Examples

The following code example creates a NamedRange and then sets the width of the columns and the height of the rows that are part of the range.

This example is for a document-level customization.

Microsoft.Office.Tools.Excel.NamedRange setColumnRowRange;
private void SetColumnAndRowSizes()
{
    setColumnRowRange = this.Controls.AddNamedRange(
        this.Range["C3", "E6"], "setColumnRowRange");
    this.setColumnRowRange.ColumnWidth = 20;
    this.setColumnRowRange.RowHeight = 25;
    setColumnRowRange.Select();
}

Private setColumnRowRange As Microsoft.Office.Tools.Excel.NamedRange

Private Sub SetColumnAndRowSizes()
    setColumnRowRange = Me.Controls.AddNamedRange( _
        Me.Range("C3", "E6"), "setColumnRowRange")
    Me.setColumnRowRange.ColumnWidth = 20
    Me.setColumnRowRange.RowHeight = 25
    setColumnRowRange.Select()
End Sub

Remarks

One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used.

Use the Width property to return the width of a column in points.

Applies to

Share via