Grid Formatting Demo

[madscijr]

Again, you're not maintaining your set ratios.  

This was the problem - and I figured out why this was happening: 

At some point I had the "bright idea" to "tweak" the logic to minimize unused space by incrementing or decrementing by a single row or column, where 

IF NumRows * (NumColumns +1) >= ItemCount
or 
IF (NumRows+1) * NumColumns >= ItemCount

then it would settle on that as the final number of rows/columns.

However, this had the undesired side effect that the ratio would now be altered.

Later, I totally forgot I had been playing with that idea, and consequently never went back to clean up the code and remove that logic. DOH! 

Thanks again for sharing your solution - very clean and compact, too!