Printing page with specific columns in excel

Originally Posted by ctlqt12

In my excel ( Info.xls ). I have 150 columns and 40 rows. And i want to print 30 columns / page. And if i have 150 columns, i will have 5 pages.

How could i print Info.xls into 5 pages with 30 columns / page by using Macro?

Hi,

Manually you would select a column (31), row 1 = AE1 and Insert Pagebreak

Please Login or Register  to view this content.

hth
---