Set a Single Column of Data to Print on X pages (Excel Macro)
Category:
Office/VBAType:
ModulesDifficulty:
IntermediateAuthor:
Dave HawleyVersion 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: