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,...
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.