I echo macropod's comment. Do supply a file to play with.
I recently responded to a similar request here: http://www.excelguru.ca/forums/showt...ll=1#post28751
which could be adapted for your purposes.