TableRange2 属性 (Excel)PivotTable.TableRange2 property (Excel)

返回一个**range** 对象, 该对象代表包含整个数据透视表 (包括页字段) 的区域。Returns a Range object that represents the range containing the entire PivotTable report, including page fields. 此为只读属性。Read-only.

语法Syntax

表达式TableRange2expression.TableRange2

_表达式_一个代表**PivotTable** 对象的变量。expression A variable that represents a PivotTable object.

注解Remarks

TableRange1 属性不包含页面字段。The TableRange1 property doesn't include page fields.

示例Example

本示例选定整个数据透视表,包括页字段。This example selects the entire PivotTable report, including its page fields.

Worksheets("Sheet1").Activate 
Range("A3").PivotTable.TableRange2.Select 

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.