Write a Jagged array containing value and FormulaR1C1 to excel.

[jayakrishnangounder]

I have a jagged array containing normal values and formulas in R1C1 notation and I want to write it into excel.

I used following code for the same

dataRange.Value2 = jaggedArray;

But it produced unexpected results in case of column anchored formulas like '=$A1'.

I got it fixed by rewriting the code:

dataRange.FormulaR1C1 = jaggedArray;

But I am not sure whether it's a perfect solution for my situation.

Thanks.

 

[sijpie]

If it works OK, then it is the perfect solution.

Indeed if the array contains formulas then you write them back to the sheet using

Range.Formula = myArray  'or
Range.FormulaR1C1 = myArray 'depending on how the formulas are stored