<div>
<br />
for r = 2 to 5000 'assumes you'll always have less than 5000 rows<br />
&nbsp; &nbsp;if range(&quot;C&quot; &amp;&nbsp;r).value &lt;&gt;&nbsp;&quot;&quot; then range(&quot;D&quot; &amp;&nbsp;r).FormulaR1C1 = &quot;=IF(ISBLANK(RC[-2]),R[-1]<wbr />C,(RC[-2])<wbr />)&quot;
</div>



for r = 2 to 5000 'assumes you'll always have less than 5000 rows
   if range("C" & r).value <> "" then range("D" & r).FormulaR1C1 = "=IF(ISBLANK(RC[-2]),R[-1]C,(RC[-2]))"

<div>
Dude, Chris. &nbsp;Thanks for the quick response. &nbsp;This is exactly what I was looking to do! &nbsp;
</div>


Dude, Chris.  Thanks for the quick response.  This is exactly what I was looking to do!  

<div>
<div class="content wysiwyg-content">
Hey everyone,<br />
<br />
I am working on a macro in excel and I am having some issues with an autofill function. &nbsp;I am trying to autofill a formula for all rows that have a value in column C. &nbsp;My issue with my current macro is this....<br />
when i recorded the macro, the macro recorded that i wanted to autofill the formula for cells D2:D539. &nbsp;<br />
VBA code example:<br />
ActiveCell.FormulaR1C1 = &quot;=IF(ISBLANK(RC[-2]),R[-1]<wbr />C,(RC[-2])<wbr />)&quot;<br />
&nbsp; &nbsp; Range(&quot;D2&quot;).Select<br />
&nbsp; &nbsp; Selection.AutoFill Destination:=Range(&quot;D2:D53<wbr />9&quot;)<br />
<br />
<br />
The number of rows will change each time I run this macro, could be more, could be less. &nbsp;That is why I would like to apply this formula to only cells where the Same row column C has a value. &nbsp;Is there a code i can type into this VBA string to help?<br />
Thanks!
</div>
</div>


Hey everyone,

I am working on a macro in excel and I am having some issues with an autofill function.  I am trying to autofill a formula for all rows that have a value in column C.  My issue with my current macro is this....
when i recorded the macro, the macro recorded that i wanted to autofill the formula for cells D2:D539.  
VBA code example:
ActiveCell.FormulaR1C1 = "=IF(ISBLANK(RC[-2]),R[-1]C,(RC[-2]))"
    Range("D2").Select
    Selection.AutoFill Destination:=Range("D2:D539")


The number of rows will change each time I run this macro, could be more, could be less.  That is why I would like to apply this formula to only cells where the Same row column C has a value.  Is there a code i can type into this VBA string to help?
Thanks!

Excel Macro Question - Autofill formula

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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