Delighted to hear. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Hjordan" wrote in message
...
Thanks Max! I tested it and it worked perfectly. I figured it had
something
to do with dividing the row number and using the remainder, but I couldn't
get it all put together correctly in a formula. This is definitely
something
I will use in the future and I appreciate that this solution doesn't
require
writing a macro.