absolute reference r1c1 code

's Computer Specifications

How do I turn this so the first cell is an absolute reference? When I delete
the [] around the -1, I get an error message. Thanks.

ActiveCell.FormulaR1C1 = "=round(R[-1]c[0]*RC[7],2)"

's Computer Specifications

Try the below

'Column and row locked
ActiveCell.FormulaR1C1 = "=round(R" & ActiveCell.Row - 1 & "C" & _
ActiveCell.Column & "*RC[7],2)"

'Row locked
ActiveCell.FormulaR1C1 = "=round(R" & ActiveCell.Row - 1 & "C*RC[7],2)"

If this post helps click Yes
---------------
Jacob Skaria

"SLP" wrote:

> How do I turn this so the first cell is an absolute reference? When I delete
> the [] around the -1, I get an error message. Thanks.
>
> ActiveCell.FormulaR1C1 = "=round(R[-1]c[0]*RC[7],2)"

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA r1c1 absolute previous row in formula	SLP	Microsoft Excel Programming	3	6th Nov 2009 05:01 PM
Combining R1C1 and absolute reference in SUMPRODUCT in VBA	=?Utf-8?B?Q29ybmVsaWE=?=	Microsoft Excel Programming	1	15th Jun 2006 10:30 PM
How to code with the R1C1 Style of Reference?	plh	Microsoft Excel Programming	3	22nd Apr 2006 07:31 PM
See code enclosed - Convert to formulas with absolute reference inculding the sheet references!	Maria J-son	Microsoft Excel Programming	0	10th May 2005 08:40 AM
Absolute reference in R1C1 notation	Tim C	Microsoft Excel Programming	2	14th Aug 2003 11:54 PM