After struggling with this most of the night, I found that the problem was in passing my parameters to the macro. Once I finally went to bed, I was laying there, and it dawned on me that there were some really good reasons to leave the script as a SUB instead of calling it as a MACRO anyways.
- there is a parameter to specify the percentage of the shelves to fill, as a SUB in each object, I can specify different amounts for each object, creating a more realistic look.
- This allows me to turn it on/off at the object level. I really only need to have the books on for rendering, and this way I can turn them on for the objects in view instead of every single object in the project.
So after all that.... I'm back to just inserting it as a SUB.
Thanks anyways for the offer to help!!!