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,...
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?
Yes.
Please check attached one if it works in your environment with such setting
That works just fine. Thank you again for your time and effort. In case it helps at all, I have saved my xlsm worksheet as .xlsx and attached.