Which sounds like a study task...

So how about you do some research on VBA arrays and looping through arrays. Post back with some evidence that you've made an attempt at solving this yourself and we can help you refine it.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia