"ryguy7272" wrote:

It seems to be working. What is it supposed to do? Select the used range on
Sheet2? That's what it's doing for me. I get all appropriate values for
vaData, UBound, and UBound. Maybe something got screwed up in Excel's
memory. Maybe you have to restart your computer.


HTH,
Ryan---

Ryan,
I tried copying this code into a new wookbook and it still doesn't work.
Just wondering how you had declared your variables. Here's how I declared
mine:

Dim vaData As Variant
Dim rwData As Long
Dim Data As String

I also tried to dim Data as Variant with same results.
Please let me know if you did something different.

thanks,
Jerry