Microsoft KB Archive/232472

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

Article ID: 232472

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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

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

Keywords: kbbidi kbdtacode kbprb KB232472

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.