I am trying to write a macro that will determine the orientation of the page, will determine the number of charts on the page, and then evenly space, resize, and format all the charts to fit on the page. I am very new to VBA, I understand the basic concepts of coding, however; I learned Fortran which doesn't run like the VBA program. I have tried to record a macro that would do something similar to this, but it doesn't register any of the actions I perform on the chart and only records when I select it. Any suggestions? Thanks