PrintTitleColumns 属性 (Excel) PageSetupPageSetup.PrintTitleColumns property (Excel)

返回或设置包含在每一页的左侧重复的单元格的列, 以宏语言的 A1 样式表示法中的字符串形式返回。Returns or sets the columns that contain the cells to be repeated on the left side of each page, as a String in A1-style notation in the language of the macro. 读/写 StringRead/write String.

语法Syntax

表达式PrintTitleColumnsexpression.PrintTitleColumns

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

说明Remarks

如果仅指定列的一部分,Microsoft Excel 将自动把该区域扩展为整个列。If you specify only part of a column or columns, Microsoft Excel expands the range to full columns.

将该属性设置为 False 或空字符串 (""),将会关闭标题列。Set this property to False or to the empty string ("") to turn off title columns.

该属性仅适用于工作表页面。This property applies only to worksheet pages.

示例Example

本示例将第三行定义为标题行,将第一列到第三列定义为标题列。This example defines row three as the title row, and it defines columns one through three as the title columns.

Worksheets("Sheet1").Activate 
ActiveSheet.PageSetup.PrintTitleRows = ActiveSheet.Rows(3).Address 
ActiveSheet.PageSetup.PrintTitleColumns = _ 
 ActiveSheet.Columns("A:C").Address

支持和反馈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.