[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

RE: What Does FormulaR1C1 Do?

JLGWhiz

12/15/2006 12:19:00 AM

To access VBA Help, press F11 and click on help in the VB editor window.
Then type "Formula R1C1 Poperty" in the search box.

This is from Excel Help:

You can also use a reference style
where both the rows and the columns
on the worksheet are numbered. The
R1C1 reference style is useful for computing
row and column positions in macros
(macro: An action or a set of actions you can
use to automate tasks. Macros are recorded
in the Visual Basic for Applications programming
language.). In the R1C1 style, Excel indicates the
location of a cell with an "R" followed by a row
number and a "C" followed by a column number.
Reference Meaning:
R[-2]C A relative reference
(relative reference: In a formula, the address of a
cell based on the relative position of the cell that
contains the formula and the cell referred to.
If you copy the formula, the reference automatically
adjusts. A relative reference takes the form A1.) to
the cell two rows up and in the same column

R[2]C[2] A relative reference to the cell two
rows down and two columns to the right

R2C2 An absolute reference (absolute cell
reference: In a formula, the exact address of a
cell, regardless of the position of the cell that
contains the formula. An absolute cell reference
\ takes the form $A$1.) to the cell in the second
row and in the second column

R[-1] A relative reference to the entire row above the active cell

R An absolute reference to the current row

When you record a macro, Excel records some commands
by using the R1C1 reference style. For example, if you
record a command such as clicking the AutoSum button
to insert a formula that adds a range of cells, Excel records
the formula by using R1C1 style, not A1 style, references.


"jeh78230" wrote:

> What Does This Formula Do?
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=f34ffbe8-4392-4ccc-a968-219646e37ecc&dg=microsoft.public.excel.p...