如何在Excel 2007中关闭R1C1参考样式 [英] how to switch off R1C1 reference style in Excel 2007

问题描述

我正在使用excel-2007。我想用R1C1看到smth，然后我检查了R1C1参考样式（办公室按钮 - > Excel选项 - >公式 - > R1C1参考样式）...

i'm using excel-2007. i wanted to see smth with R1C1, then i checked the "R1C1 Reference Style" (office button->Excel Options->Formulas->R1C1 Reference Style)...

现在我想再次移动到xlA1样式，我没有选中R1C1参考样式，但是我的宏仍然写在R1C1样式...我如何切换到xlA1参考样式，以便我的宏再次写入xlA1样式？谢谢

Now i wanted to move again back to xlA1 style, i unchecked the R1C1 Reference Style, but my macros are still written in the R1C1 style... how can i switch to xlA1 reference style so that my macros again written in the xlA1 style? thanks

我尝试再次录制宏不起作用。

i tried recording macros again it does not work!

推荐答案

您将不得不手动编辑代码[划出]或再次记录宏[/ scratch out]。

You will have to manually edit the code [scratch out]or record the macros again[/scratch out].

编辑：

Office按钮> Excel选项>公式> R1C1参考样式选项仅适用于在单元格中显示的参考样式一个电子表格。

The Office Button>Excel Options>Formulas>R1C1 Reference Style option only applies to the reference style as it appears in a cell on a spreadsheet.

使用R1C1参考样式 关闭 ，我记录了一个宏，其中A2最初选择。记录仪启动后，进入A2的下列论坛： = A1 + 12 ，按回车并停止录像机。记录的代码是：

With the R1C1 reference style off, I recorded a macro in which cell "A2" is initially selected. After the recorder starts, I enter the following forumla into "A2": =A1+12, press enter and stop the recorder. The recorded code is:

ActiveCell.FormulaR1C1 = "=R[-1]C+12"
Range("A3").Select

使用R1C1参考样式 > ，代码看起来完全一样：

With the R1C1 reference style on, the code looks exactly the same:

ActiveCell.FormulaR1C1 = "=R[-1]C+12"
Range("A3").Select

原因是宏记录器总是将公式存储在 ActiveCell对象 的 FormulaR1C1属性 中。

The reason is that macro recorder always stores the formula in the FormulaR1C1 property of the ActiveCell object.

人们必须手动将这样的代码编辑为xlA1样式：

One would have to manually edit the code like this to be in xlA1 style:

ActiveCell.FormulaR1C1 = Range("A1").Value + 12

这篇关于如何在Excel 2007中关闭R1C1参考样式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！