<div>
Yup worked great. &nbsp;Thanks.
</div>


<div>
Rory you are very fast :-) <br />
<br />
<br />
until i open the question, i see it is answered on the fly :-)
</div>


Rory you are very fast :-)


until i open the question, i see it is answered on the fly :-)

<div>
<div class="content wysiwyg-content">
Why would this produce a 1,2,3.... down the column instead of a 01,01,01,01?? &nbsp;I need a value specifically of &quot;01&quot; but it is not copying it down? &nbsp;Any ideas? &nbsp;I have tried just every cell format I can find? &nbsp;Can this be done without using Autofill?<br />
<br />

<pre><code id="code-10-28546914-1">    Range(&quot;J3&quot;).Select
    ActiveCell.FormulaR1C1 = &quot;01&quot;
'Copies the formula in J3 down column J, as long as there is a value in columnG
    Set MyRange = Range(Range(&quot;J3&quot;), Range(&quot;J&quot; &amp; Range(&quot;G3&quot;).End(xlDown).Row))
    Range(&quot;J3&quot;).AutoFill Destination:=MyRange</code></pre>
</div>
</div>


Why would this produce a 1,2,3.... down the column instead of a 01,01,01,01??  I need a value specifically of "01" but it is not copying it down?  Any ideas?  I have tried just every cell format I can find?  Can this be done without using Autofill?

(CODE)

Copying a cell value down a column.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.