Debra -
Your approach sounds pretty intuitive! I can now see what why my
"rng" variable was not looping.However, I can only test your code at
work on Monday. I have a question though:
Why does your Long variable "myRow" initialize from 1 and not
dir.Row+1?

Thanks.

Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!