Excel vba : assign all properties to a cell from an array of range
<p>My goal is to save a Cell and all its properties and value in an array of range, and then write back all properties and values of this cell to another cell from the array (like a copy paste function but pasting from the array).</p>

<p>Here is a simple test procedure :</p>

<pre><code>Sub Test()
    Dim Range_Grid(1) As Range
    Dim CellAdress As String
    Dim i As Long

    Set Range_Grid(1) = ActiveSheet.Cells(2, 3)
    ActiveSheet.Cells(4, 1) = Range_Grid(1)
End Sub
</code></pre>

<p>So here in the first element of the array Range_Grid(1), I really get the full range saved and I can access every property the original range ActiveSheet.Cells(2, 3) had, like font style, format, color, comment, etc..</p>

<p>But when I try to write this range from array to another empty cell, it only write the value...</p>

<p>Any idea how to write all the properties from the array like if it was a copy/paste from sheet to sheet?</p>