FormulaR1C1 的功能是什么? [英] What is the function of FormulaR1C1?

问题描述

我一直将 FormulaR1C1 视为一个函数，它究竟是如何工作的?我理解互联网上所说的第 1 行第 1 列，但人们实际上是如何使其工作的?使用FormulaR1C1的最终结果是什么?

I have been looking at FormulaR1C1 as a function, how does this exactly work? I understand what has been said all over the internet which is stands as Row 1 Column 1, but how do people actually make it work? What is the end result of using FormulaR1C1?

还可以将其更改为从工作表中的特定点开始，还是始终为 R1C1?那么它可能是FormulaR2C3吗?

Also can it be changed to start at a specific point in a sheet, or it always going to be R1C1? So could it be FormulaR2C3?

推荐答案

FormulaR1C1 的行为与公式相同，仅使用 R1C1 样式注释，而不是 A1 注释.在 A1 注释中，您将使用:

FormulaR1C1 has the same behavior as Formula, only using R1C1 style annotation, instead of A1 annotation. In A1 annotation you would use:

Worksheets("Sheet1").Range("A5").Formula = "=A4+A10"

在 R1C1 中，您将使用:

In R1C1 you would use:

Worksheets("Sheet1").Range("A5").FormulaR1C1 = "=R4C1+R10C1"

它不会作用于第 1 行第 1 列，而是作用于目标单元格或范围.第 1 列与 A 列相同，因此 R4C1 与 A4 相同，R5C2 为 B5，依此类推.

It doesn't act upon row 1 column 1, it acts upon the targeted cell or range. Column 1 is the same as column A, so R4C1 is the same as A4, R5C2 is B5, and so forth.

该命令不会更改名称，而是更改了目标单元格.对于您的 R2C3(也称为 C2)示例:

The command does not change names, the targeted cell changes. For your R2C3 (also known as C2) example :

Worksheets("Sheet1").Range("C2").FormulaR1C1 = "=your formula here"

这篇关于FormulaR1C1 的功能是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！