Alaska Software Inc. - FormulaR1C1 for ActiveX
Username: Password:
AuthorTopic: FormulaR1C1 for ActiveX
=?UTF-8?Q?C=c3=a9sar_Calvo?= FormulaR1C1 for ActiveX
on Sun, 03 Jun 2018 12:46:11 +0200
Good morning, time ago I got to know how write the FormulaR1C1 for get 
put the value of A2 in B2 but I have lost the source and I am not 
remember how I did it.
Could anybody help me?
Regards.
César

This is with VBA:
ActiveCell.FormulaR1C1 = "="""" & RC[-1]"

I am trying with:
oExcel:ActiveCell:FormulaR1C1 := '=""' + '&' + 'RC[-1]'

But


Libro1.xlsx
ERROR LOG of.docx
Jonathan LeemingRe: FormulaR1C1 for ActiveX
on Sun, 03 Jun 2018 08:49:51 -0600
On 6/3/2018 4:46 AM, César Calvo wrote:
> Good morning, time ago I got to know how write the FormulaR1C1 for get 
> put the value of A2 in B2 but I have lost the source and I am not 
> remember how I did it.
> Could anybody help me?
> Regards.
> César
> 
> This is with VBA:
> ActiveCell.FormulaR1C1 = "="""" & RC[-1]"
> 
> I am trying with:
> oExcel:ActiveCell:FormulaR1C1 := '=""' + '&' + 'RC[-1]'
> 
> But
> 
Hi,

I have was not aware of the FormulaR1C1 option prior to your post as I 
had always used the "plain" Formula with A1 notation.

I have since played around with it and found that using...

oExcel:ActiveCell:FormulaR1C1 := "=RC[-1]" should work.

Hope this helps... Jonathan

jonathan.leeming@the-family-centre.com
Edmonton, Alberta, Canada
=?UTF-8?Q?C=c3=a9sar_Calvo?= Re: FormulaR1C1 for ActiveX
on Sun, 03 Jun 2018 20:41:44 +0200
El 03/06/2018 a las 16:49, Jonathan Leeming escribió:
> On 6/3/2018 4:46 AM, César Calvo wrote:
>> Good morning, time ago I got to know how write the FormulaR1C1 for get 
>> put the value of A2 in B2 but I have lost the source and I am not 
>> remember how I did it.
>> Could anybody help me?
>> Regards.
>> César
>>
>> This is with VBA:
>> ActiveCell.FormulaR1C1 = "="""" & RC[-1]"
>>
>> I am trying with:
>> oExcel:ActiveCell:FormulaR1C1 := '=""' + '&' + 'RC[-1]'
>>
>> But
>>
> Hi,
> 
> I have was not aware of the FormulaR1C1 option prior to your post as I 
> had always used the "plain" Formula with A1 notation.
> 
> I have since played around with it and found that using...
> 
> oExcel:ActiveCell:FormulaR1C1 := "=RC[-1]" should work.
> 
> Hope this helps... Jonathan
> 

Thansk Jonatan.
I have solved this with:

 COLUMNA L: RAEE

oExcel:Columns("M:M"):Select
oExcel:Selection:Insert(xlDown, xlFormatFromLeftOrAbove)

oExcel:Range("M2"):Select
oExcel:ActiveCell:Formula := '=""&L2'
oExcel:Selection:Copy