XL2000: BottomRightCell VBA Property Returns Bottom-Left Cell Address in Right-to-Left Worksheet

ID: Q232472

The information in this article applies to:

Microsoft Excel 2000

NOTE: This article discusses complex scripts functionality. Complex scripts functionality is available when you use the Office Language Settings tool to enable a language, such as Arabic or Hebrew, that requires this functionality. For more information about multilingual features, click Microsoft <your Office product> Help on the Help menu, type multilingual features in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

SYMPTOMS

The BottomRightCell property in Microsoft Visual Basic for Applications returns the bottom-left cell address instead of the bottom-right cell address.

CAUSE

This behavior occurs when you use the BottomRightCell property on an Excel worksheet of a right-to-left language (bidirectional) workbook.

MORE INFORMATION

In both left-to-right and right-to-left language worksheets, the BottomRightCell property returns the cell address of the bottom "far" cell; where "far" refers to the bottom cell location that is farthest from column A in the worksheet. Thus, for right-to-left language worksheets, this is actually the bottom-left cell.

Right-to-left worksheets were not anticipated when the BottomRightCell property in Visual Basic for Applications was originally created and named. The name of the property was not changed in order to maintain compatibility with non-bidirectional workbooks.

NOTE: The TopLeftCell property always returns the top-left cell regardless of whether a bidirectional language is enabled or not.

Additional query words: bidi bi-di bi-directional vba right left arabic hebrew XL2000

Keywords : kbdta kbdtacode OffVBA kbBidi KbVBA
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb