Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
absolute reference r1c1 code
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)" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
absolute reference r1c1 code
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)" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
absolute reference r1c1 code
You can always use A1 addressing Cell1Addr = cells(Activecell.Row - 1,ActiveCell.column).address Cells2Addr = cells(activecell.Row,Activecell.column + 7).address ActiveCell.Formula = "=round(" & Cell1Addr & "*" & Cell2Addr & ",2)" -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151771 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA r1c1 absolute previous row in formula | Excel Programming | |||
Combining R1C1 and absolute reference in SUMPRODUCT in VBA | Excel Programming | |||
How to code with the R1C1 Style of Reference? | Excel Programming | |||
See code enclosed - Convert to formulas with absolute reference inculding the sheet references! | Excel Programming | |||
Absolute reference in R1C1 notation | Excel Programming |