Microsoft Office Tutorials and References
In Depth Information
Table 26-1. Properties and Methods of the Object (continued)
Property or Method
This method lets you change the range of cells associated with the
list. If the list draws its data from a source on a SharePoint site,
you can only add rows, not columns. The method doesn’t delete
any existing data.
This method breaks the link between the ListObject and a source
on a SharePoint site. No data is deleted.
This method removes data list functionality from the list. The cells
in the ListObject become regular cells and retain their data.
This method updates the list on a SharePoint site with the changes
made to the list in the worksheet. The optional XlListConflict
constant can be any of these intrinsic constants:
xlListConflictDialog (the default, which displays the Conflict dialog
box), xlListConflictRetryAllConflicts (which attempts to update the
data again), xlListConflictDiscardAllConflicts (which ignores any
changes that conflict with other users’ changes), and
xlListConflictError (which indicates an error and halts the update).
All the data lists in a worksheet have a place in the Wo rksheet object’s ListObjects collection.
The collection starts out empty, but you can use the collection’s Add method to create a new
ListObject in the worksheet that calls the method.
The ListObjects.Add method has the following syntax:
expression.Add(SourceType, Source, LinkSource, HasHeaders, <;$RD>
Table 26-2 details the Add method’s arguments.
Table 26-2. Arguments of the ListObjects Collection’s Add Method
Required or Optional
An expression that returns a ListObject
One of two XlListObjectSourceType
constants: xlSrcExternal , which indicates an
external data source, or xlSrcRange (the
default), which indicates the data source is
a range in a workbook.