Set a Single Column of Data to Print on X pages (Excel Macro)

Category:
Office/VBA
Type:
Modules
Difficulty:
Intermediate
Author:
Dave Hawley

Version Compatibility: Visual Basic 6

More information:
This macro will take a single column of data delimited by page breaks and move the data in the even-numbered pages to the next column, cutting down the number of pages in the worksheet.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: