Print in Two Columns

Sorry... but Highly confusing.

Will File -> Print Area -> Set Print Area work for you?

If not, please specify your problem clearely, and what do you mean by printing in two columns??

Have a look at the "paper saver" in the free addin from http://www.asap-utilities.com. That should do what you want

There's an example in Ozgrid's main site to download from the Workbooks Download section of the VBA articles. Title is PrintCol.zip

I’m sure your find to get you started and workable solution look into setting up a printable area to this Excel document

Caution: When you print you only get the ranges that were selected to print

IE : Two Columns only

Is that what you are looking for.

Kindest possible regards

Jack in the UK