范围: Hidden 属性 (Excel)Range.Hidden property (Excel)

返回或设置一个 Variant 值,它指明是否隐藏行或列。Returns or sets a Variant value that indicates if the rows or columns are hidden.

语法Syntax

表达式隐藏expression.Hidden

expression 一个表示 Range 对象的变量。expression A variable that represents a Range object.

注解Remarks

将此属性设置为 True 以隐藏行或列。Set this property to True to hide a row or column. 指定的区域必须占据整个行或整个列。The specified range must span an entire column or row.

请勿将此属性与**FormulaHidden** 属性混淆。Don't confuse this property with the FormulaHidden property.

示例Example

此示例隐藏 Sheet1 的 C 列。This example hides column C on Sheet1.

Worksheets("Sheet1").Columns("C").Hidden = True

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