You can remove the line: myRow = 1

I think it's a remnant of an earlier approach to the problem, and isn't
required now.


jay dean wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html