XL97: Incorrect Formula Using FormulaR1C1 When Chart Active

ID: Q186047

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

The Microsoft Visual Basic for Applications FormulaR1C1 property does not set a formula reference properly if a chart is active.

NOTE: This is different behavior from earlier versions of Microsoft Excel and Microsoft Visual Basic for Applications.

CAUSE

This problem occurs when a chart sheet or embedded chart on a worksheet is active, and you run a Visual Basic Sub procedure that uses the FormulaR1C1 property to place a formula in a cell.

WORKAROUND

Activate one of the following sheet types before executing a line of Visual Basic code that includes the FormulaR1C1 property:

Worksheet
MS Excel 4.0 Macro
MS Excel 5.0 Dialog

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about the FormulaR1C1 Property, from the Visual Basic Editor, click the Office Assistant, type "FormulaR1C1 Property," click Search, and then click to view "FormulaR1C1 Property."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q176476
   TITLE     : OFF: Office Assistant Not Answering Visual Basic Questions

For more information about getting help with Visual Basic for Applications, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q163435
   TITLE     : VBA: Programming Resources for Visual Basic for
               Applications

Additional query words: XL97

Keywords          : kbdta KbVBA 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: January 8, 1999