Thank you guys!

I actually used both of your solutions in my model, and both macros are helping me to do exactly what I wanted them to do! :-)