Dynamic print area, multiple sheets with Office Script button

[jaeiow]

Hello,

I am hoping I can accomplish the following.

setPrintArea(printArea)

Set the print area to the dynamic array on the active sheet. Use same cell X2# on all printing sheets. There are twelve. Twelve buttons, one Script.

Has anyone done this before? I read about dynamic print ranges, but this only works if there is one sheet.

I usually start with recording code from xcel online, but they do not have a name manager.

 

[jaeiow]

hmm, it works sans office scripts. I just had to set up the named ranges on each spill, and then reference those from worksheet-scoped names.