Forum Discussion
Why isn't my OFFSET formula to set dynamic print area working?
I need help as to why all of my attempts to set a dynamic print range have no effect. I believe that my initial formula should work: =OFFSET(‘Customer Receipt’!$A$4,0,0,10+’Customer Receipt’!$G$10,8)
I have tried other approaches, including VBA, and all result in printing the entire worksheet. Performing the standard Set Print Area works, but not what I need.
11 Replies
Hi Michelle,
In general dynamic print area works if you set it that way https://www.myonlinetraininghub.com/excel-factor-5-dynamic-print-area
Thank you for your response. I have attached screen print showing that I have set up as you suggest. When I go to print, it prints entire worksheet as if there were no print area set at all.
Michelle, when you print do you have "Customer Receipt" as active worksheet?
