Assuming myarray is a 2-D array:
rw = Ubound(myarray,1)-lbound(myarray,1)+1
col = Ubound(myarary,2)-lbound(myarray,2)+1
Range("A1").Resize(rw,col).Value = myArray
--
Regards,
Tom Ogilvy
mudraker wrote in message
...
Tom
This looks exactly like what I am after
Is there a simular simple way to fill a sheet with data held in an
Array
Thanks
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/