Transfering data from a column in an array to a worksheet

[nrichmond]

Hi,

I have a load of data stored in an array and have written something (or cut and paste cobbled together more accurately) that locates a particular name at the top of a column within that array. What I want to do is then select all the contents of that column and paste it into a worksheet.

Any ideas anyone?

Thanks,
Nick