<div>
pardon my stupidity, my fault<br />
<br />
thanks!!!
</div>


<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
I am trying to copy paste a formula down to a certain row.<br />
=MAX(U2:$U$2)-U2<br />
<br />
When I use copy/paste.formula, &nbsp;the exact formula gets copied... (not incrementing the U2 - without the $)<br />
<br />
When I use Range.formulaR1C1<br />
the formula changes to <br />
=MAX(U$2:$U3)-U3<br />
<br />
Any idea how to make the second copy =MAX(U3:$U$2)-U3<br />
so on and so on??<br />
<br />
thansk!!!
</div>
</div>


Hi Guys,

I am trying to copy paste a formula down to a certain row.
=MAX(U2:$U$2)-U2

When I use copy/paste.formula,  the exact formula gets copied... (not incrementing the U2 - without the $)

When I use Range.formulaR1C1
the formula changes to 
=MAX(U$2:$U3)-U3

Any idea how to make the second copy =MAX(U3:$U$2)-U3
so on and so on??

thansk!!!

copy paste formula vba

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