thanks mike. that was helpful. i was able to mod your code to fit my needs. the only thing that gave me a fuss was there needs to be "Set" at the beginning of the 5th line of code. with that fixed it was working great. thanks again.