ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Group and adjust columns for several sheets (https://www.excelbanter.com/excel-programming/371902-group-adjust-columns-several-sheets.html)

J.W. Aldridge

Group and adjust columns for several sheets
 
I need a code that will do the following:

(1) Group sheets - starting with sheet x (all sheets in between) and
ending with sheet z.
(2) self adjust column width for columns A:G and I:K to fit the text in
those columns.
(3) set print area (based on last column used) to 1 page, (landscape).
Range A1:K?
(4) print each sheet within the range (sheet x to sheet z)


Possible?



All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com