Application.DefaultSheetDirection Property (Excel)
Returns or sets the default direction in which Microsoft Excel displays new windows and worksheets. Can be one of the following constants: xlRTL (right to left) or xlLTR (left to right). Read/write Long.
Syntax
expression .DefaultSheetDirection
expression A variable that represents an Application object.
Remarks
Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you’ve selected or installed.
Example
This example sets right to left as the default direction.
Application.DefaultSheetDirection = xlRTL