This might work

You can use this before the load:

Application.Calculation = xlManual

After load is done you can turn it back to automatic:

Application.Calculation = xlAutomatic


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=536080