XL2000: BottomRightCell VBA Property Returns Bottom-Left Cell Address in Right-to-Left Worksheet (232472)
The information in this article applies to:
This article was previously published under Q232472 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 <I BRACKET="YES">your Office product</I> Help on the Help menu, type multilingual features in the Office Assistant or the Answer Wizard, and then click Search to view the topics that are 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. Therefore, 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.
| Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
|---|
| Keywords: | kbBidi kbdtacode kbprb KB232472 |
|---|
|