Hi there – I’d like a dynamic print range to be coded in the
Workbook_BeforePrint sub. Here are the specs: from B1 down to the
last row of data (where some rows are skipped) -- over to the last
column of data based on row 12 (row 12 will always be the last data
col) -- and do this for 7 sheets (Name 1, Name 2…., Name 7) named with
the same prefix, like "Name _". Any help on this would be greatly
appreciated, as setting the print range manually is no fun. Thanks!