Tom,

Thank you for responding. To clarify, I am bringing in
5,000 - 10,000 rows of data calculated from another
sheet. The existing data goes through column "AN", the
formulas I have been pulling down make new calculations
from the data in columns "A" - "AN". The column I am
pulling the formulas down to is initially empty except for
the first rows, which have headings and one row of
formulas from the previous data.

If I understand you correctly, I would change A2 in the
macro to the first cell address that I would need to pull
down formulas, "AM11"? The last column with formulas to
pull down is "CS". That is "AM" through "CS" are all
being pulled down.

Please advise.

Regards, Tim

-----Original Message-----
Sub Tester1()
Range("A2").Resize(1, 30).Copy _
Destination:=Range("A2").Resize(10001, 30)
End Sub

Might do what you want if your formulas are constructed
appropriately.

Since you say through rows of data, then you might have
to go a column at a
time if the new columns are not contiguous. If you are
adding columns to
the end of your data, change A2 to the second row of the
first column.

--
Regards,
Tom Ogilvy



_______Tim_______ wrote in message
...
Hi,

If anyone knows an alternative to pulling down 30
columns
of formulas through 10,000 rows of new data, please,
please, please let me know.

Regards, Tim



.