Muokkaa

Jaa

CustomView.RowColSettings property (Excel)

  • Artikkeli

True if the custom view includes settings for hidden rows and columns (including filter information). Read-only Boolean.

Syntax

expression.RowColSettings

expression A variable that represents a CustomView object.

Example

This example creates a list of the custom views in the active workbook and their print, row, and column settings.

With Worksheets(1) 
 .Cells(1,1).Value = "Name" 
 .Cells(1,2).Value = "Print Settings" 
 .Cells(1,3).Value = "RowColSettings" 
 rw = 0 
 For Each v In ActiveWorkbook.CustomViews 
 rw = rw + 1 
 .Cells(rw, 1).Value = v.Name 
 .Cells(rw, 2).Value = v.PrintSettings 
 .Cells(rw, 3).Value = v.RowColSettings 
 Next 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.