Lem,

I get what you are saying and your explanation makes sense, but 6,6,4 would be better if I wanted three columns because I am trying the maximize the data per column. The macro seems to accomplish that, but now I am wondering if it can be done using an array...

The helpful thing with regards to the macro would be able for the user to define the number of rows per column without having to modify the code (as described above).