HTMLData Property
PivotTable and Range objects: Returns a String that represents the specified PivotTable list or range as a properly-formatted HTML string. Read-only.
Spreadsheet object: Returns or sets a String that represents the spreadsheet data as a properly-formatted HTML string. Read/write.
expression.HTMLData
expression Required. An expression that returns one of the object in the Applies To list.