SpreadsheetLayout.DataArea

This property returns the data format of a spreadsheet layout.

This property is read only.

Syntax Parameters Return Value
- - Format

SVB Example

Customizing the default spreadsheet layout: 

Option Base 1
Option Explicit
Sub Main
    Dim sprlayout As SpreadsheetLayout
    'assings sprlayout to the existing layout "System Default"
    Set sprlayout = Application.SpreadsheetLayouts.Item("System Default")
    'changes the orientation setting for data displayed within the data area to vertical
    sprlayout.DataArea.Orientation = scVertical
    'access the column headers format by name from within the formats collection
    'the effect 3d property for this format is then changed to false
    sprlayout.Formats("Column Headers").Effect3D = False
End Sub