Absolute reference - insertion of the equivalent of '$' into the equation written in R1C1 notation

Question

I have this equation that I use VBA to enter a cell in my spreadsheet:

ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],RC[-1]:R[" & CellNumber & "]C[-1],1,0)"

How do I enter a formula with signs $to preserve cell references?

I tried adding $to their respective positions in the formula, but that didn't work.

+3

Numberjuan Feb 14 '14 at 2:37

1 answer

pnuts · Accepted Answer · 2014-02-14T03:36:52+0000

, , , (i) (ii) R C, R1C1, Row 1, Column1 - A1 ( R1C1 , - , R1C1).

RC[-3] , - ( R , ) ( ) , .

, D1, RC[-3] , R1C1, , A1.

, , RC[-3] E1, B1, R1C1 ( $A $1) A1 , .

Active Cell - , , " , ". , , , , ( /), .

, , " ", " 4".

, "" - "" ( , RTL).

[ ] " , ".

" " "" "".