>I have it workin with the clipboard.
>The only drawback is that stuff cames back as characters only. but other than tat it works fine
>
>Peter
Of course, you can also get the individual cells, with loSheet.Cells(lnRow, lnCol).Value.
It really depends a lot on the size of the range. I wouldn't worry about speed if you typically select a few pages, at most.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)