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/