<div>
Hi,<br />
<br />
The code you want is....<br />
<br />
Sub Copying()<br />
&nbsp; &nbsp; Range(&quot;D1&quot;, Range(&quot;C65536&quot;).End(xlUp).<wbr />Offset(0, 1)).Select<br />
End Sub<br />
<br />
This will select D1:D??? based on column C being filled....i.e. if column C is filled to row 13 then Range D1:D13 will be selected.<br />
<br />
Hope this helps<br />
<br />
Frazer<br />

</div>


Hi,

The code you want is....

Sub Copying()
    Range("D1", Range("C65536").End(xlUp).Offset(0, 1)).Select
End Sub

This will select D1:D??? based on column C being filled....i.e. if column C is filled to row 13 then Range D1:D13 will be selected.

Hope this helps

Frazer


<div>
This also assumes you are using excel 97, if you are not you will need to change C65536 to C16384...<br />
<br />
Frazer<br />

</div>


This also assumes you are using excel 97, if you are not you will need to change C65536 to C16384...

Frazer


<div>
<div class="content wysiwyg-content">
Having recorded an extensive VB macro which sorts, adds/deletes, modifies, and recalculates a fairly large ASCII file, I run in to a problem when additional records are added to this file. &nbsp;Initially, part of the macro was set to copy a formula in cell D1 and paste it to an inserted column C1:C1129. &nbsp;Now that additional records have been added, the macro still only pastes to the extent of C1129. &nbsp;How can I have the macro copy the information in cell D1 and paste it to an (un)-predetermined amount of rows in column C to compensate for any additional records added? &nbsp;
</div>
</div>


Having recorded an extensive VB macro which sorts, adds/deletes, modifies, and recalculates a fairly large ASCII file, I run in to a problem when additional records are added to this file.  Initially, part of the macro was set to copy a formula in cell D1 and paste it to an inserted column C1:C1129.  Now that additional records have been added, the macro still only pastes to the extent of C1129.  How can I have the macro copy the information in cell D1 and paste it to an (un)-predetermined amount of rows in column C to compensate for any additional records added?  

MS Excel VB copying a formula in to an undertermined amount of rows

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.