paste array into userform - is it possible

[ferday]

i have 27 arrays that are to be pasted into a sheet. the problem is the size is dynamic (always 3 columns, but anywhere from 100 - 10000+ rows)

currently i have them all on a sheet side by side, and the code works fine and all that (thanks to much help here!). however, the sheet is a mess, since i have 85 rather wide columns...the generally non-excel-inclined people who are using it are doing a lot of mis-pasting

so my question is: is it even possible to paste the data (3 columns by N rows, csv file) into some sort of user form / input box type situation, so it can simply ask them outright to paste "the correct" data, then have the sheet populate from that?

i have a suspicion it's not but who knows

thanks

[Neil_]

1. Lock the sheet down.
2. Put a button on the sheet that the paste-ees (pasties?) can click
3. code behind the button to validate and manipulate the clipboard

Try this link for instructions on manipulating the clipboard.
http://www.cpearson.com/excel/Clipboard.aspx

[Neil_]

or...
Have an 'input' sheet to paste the data in. Once pasted and tested by code, present the user with a dropdown to select where the data should go.

[ferday]

Thanks mate! both workable ideas, i like the clipboard thing, will experiment with it