Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: BottomRightCell VBA Property Returns Bottom-Left Cell Address in Right-to-Left Worksheet

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

View products that 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.

↑ Back to the top

Symptoms

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

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB232472, kbprb, kbdtacode, kbbidi

↑ Back to the top

Article Info
Article ID : 232472
Revision : 5
Created on : 10/10/2006
Published on : 10/10/2006
Exists online : False
Views : 223