ListRow ListRow ListRow Interface


Represents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object.

public interface class ListRow
public interface ListRow
Public Interface ListRow


Use the ListRows property of the ListObject object to return a ListRows collection.


Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.

Index Index Index

Returns the index number of the ListRow object within the ListRows collection.

InvalidData InvalidData InvalidData

Returns a Boolean value that indicates if a row in a list contains cells that don't pass data validation and need to be fixed before any changes can be committed to the Microsoft Windows SharePoint Services site.

Parent Parent Parent

Returns the parent object for the specified object.

Range Range Range

Returns a Range object that represents the range to which the specified list object applies.


Delete() Delete() Delete()

Deletes the cells of the list row and shifts upward any remaining cells below the deleted row. You can delete rows in the list even when the list is linked to a SharePoint site. The list on the SharePoint site will not be updated, however, until you synchronize your changes.

Applies to