Vba loop to start A macro
<p>I have some issues with a function.</p>

<p>I have date in column A6 to A100
I would like to do this: for each date, copy this date and start a macro base on the date.
It only copy but thats it its not working. A y idea? Thanks </p>

<p>So far I have this: </p>

<pre><code> Sub macro1
    Dim I as variant 
    Din sheet1 as worksheet
    Dim sheet2 as worksheet 

    For I = 6 to 100
    Sheet1.cells(I,1).copy
    Sheet2.cells("A3").paste

    Call macro2

    Next i

End sub
</code></pre>