R1C1 and the $ sign
 

Hello:

If I do this..
ActiveWorkbook.Worksheets("Sale").Range("E11").For mula = "=R1C1"

I get..
=$A$1 in my E11

Is there a way to get rid the dollar signs? What I want is =A1.

Thanks!
Adrian T

R1C1 and the $ sign
 

Adrian T wrote...
If I do this..
ActiveWorkbook.Worksheets("Sale").Range("E11").Fo rmula = "=R1C1"

I get..
=$A$1 in my E11

Is there a way to get rid the dollar signs? What I want is =A1.

It's SUCH a bother to read online help isn't it? There's a topic there
titled 'About R1C1 references' that explains the syntax.

However, why aren't you simply using

ActiveWorkbook.Worksheets("Sale").Range("E11").For mula = "=A1"

?

Indeed, using the .Formula property to enter formulas using R1C1
references should generate Excel formula syntax errors. So, are you
actually using the .FormulaR1C1 property?

R1C1 and the $ sign
 

Hi,

Change your Formula to:
ActiveWorkbook.Worksheets("Sale").Range("E11").For mula = "=A1"
This will givew you =A1 in E11

Charles
"Adrian T" wrote in message
...
Hello:

If I do this..
ActiveWorkbook.Worksheets("Sale").Range("E11").For mula = "=R1C1"

I get..
=$A$1 in my E11

Is there a way to get rid the dollar signs? What I want is =A1.

Thanks!
Adrian T