MS Excel VB copying a formula in to an undertermined amount of rows
Posted on 1998-08-19
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?