'xSht.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=Falseģ. XSht.Range(xArea.Address).Value = xArea.Value

XArea.Copy Destination: = xSht.Range(xArea.Address) Set xSht = Worksheets.Add(After: = Sheets(Sheets.Count)) Set xRg = Application.InputBox('Please select columns:', 'Kutools for Excel', xTxt,, ,, , 8) VBA code: Print selected columns together Sub Print_MultiAreas() And then copy and paste following VBA code into the Module window. In the Microsoft Visual Basic for Application window, click Insert > Module. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Application window.Ģ. You can print multiple selected columns together on one page with VBA code. Print selected columns together with VBA codeĮasily print selected columns together with an amazing tool If you want to print selected columns together on one page, what would you do? This article will show you methods to achieve it.

How to print selected columns together on one page in Excel?īy default, Excel divides multiple selected columns into separated pages while printing.

Openoffice columns on some pages