On Thu, 4 Aug 2005 13:27:44 -0400, "Stephen R" <nospam@nospam.com> wrote:

>Ron,
>
>Your code suggestion is the one that works with my data files.
>
>When I started a new worksheet to test, I realized my previous statement of
>Excel automatically converting the pasted data to columns is not true. But
>when I tried your code, it worked with all the areas that I need it to.
>
>Thanks again,
>
>Stephen R.

Stephen,

I'm glad you have it working for you. Thank you for the feedback.


--ron