The Columns and Rows Properties

The Columns property returns a Columns collection that represents all the table columns in the range, selection, or table. The properties and methods of the Columns collection are:

Add

Delete

Parent

Application

DistributeWidth

Select

AutoFit

First

SetWidth

Borders

Item

Shading

Count

Last

Width

Creator

NewEnum

 

and those of the Column object are:

Application

Cells

Index

AutoFit

Creator

IsFirst

Borders

Delete

IsLast

Next

Select

Sort

Parent

SetWidth

Width

Previous

Shading

 

Similarly, the Rows property returns a Rows collection that represents all the table rows in the range, selection, or table. The properties and methods of the Rows collection are:

Add

Delete

LeftIndent

Alignment

DistributeHeight

NewEnum

AllowBreakAcrossPages

First

Parent

Application

HeadingFormat

Select

Borders

Height

SetHeight

ConvertToText

HeightRule

SetLeftIndent

Count

Item

Shading

Creator

Last

SpaceBetweenColumns

and those of the Row object are:

Alignment

HeadingFormat

Parent

AllowBreakAcrossPages

Height

Previous

Application

HeightRule

Range

Range

Delete

LeftIndent

Borders

Index

Select

Cells

IsFirst

SetHeight

ConvertToText

IsLast

SetLeftIndent

Creator

LeftIndent

Shading

Delete

Next

SpaceBetweenColumns

Get Writing Word Macros, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.