Arrays are easily written to a range using the Range's Resize property.

Whether you use an array method or another, I would recommend that you turn off calculation, screen updates and events as I did in http://vbaexpress.com/kb/getarticle.php?kb_id=1035