DefaultSheetDirection Property
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.
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