Okay, and you "filled the C-F cols" with "[u]*formulas",[/*U] right? And
you don't have your calculation turned to Manual, do you? When you do
this with a large file, it takes a while for all the addresses
(formulas) to update. I did it
with 4000 records (12,000 rows), and it took a while for all the
calculations to update. Before it updates, it just looks like I copied
the
first ones.

Formulas? - as in the actual names addresses and states in col C, E &F
... YES
Calculation turned to manual?? Dont understand...
1500 records...... i tried it again and am just waiting...


--
dfkelly42
------------------------------------------------------------------------
dfkelly42's Profile: http://www.excelforum.com/member.php...o&userid=12094
View this thread: http://www.excelforum.com/showthread...hreadid=383737