To get my data in a useable format, I have to paste 1000-3000 lines of data
(copied from an intranet site) from the clipboard to the spread sheet.
Unfortunately, pasting as text or other formats does not give the data in
parseable form. This is slow.

I haven't been able to get Web Query to work, but even if I did, I am not
sure it would serve my purpose since the user has to go to a different web
page each time.

Is there some way I could paste it first to an array and then transfer? Or
do you have some other suggestion.Is there a way to refer to "the clipboard
contents" in visual basic and paste it directly to an array and then paste
the array to the spread sheet? I am only guessing that it it may be quicker
to do it this way. Also once I had it in an array, I could do the
manipulations quicker although perhaps the VLOOKUP function would be faster
than any looping that I could do through an array.

If it helps to understand what I am talking about, email me at
and I'll send an example of my program with data already
pasted into it.



Thank you for your help,

Darin