|
|
Article: Wrapping rows with Excel VBA.(visual basic for applications)
- Article from:
- Personal Computer World
- Article date:
- February 21, 2008
- Author:
CopyrightCOPYRIGHT 2008 Incisive Media, published with the permission of Incisive Media. This material is published under license from the publisher through the Gale Group, Farmington Hills, Michigan. All inquiries regarding rights should be directed to the Gale Group. (Hide copyright information)
|
Byline: Tim Anderson
Wrapping rows with Excel VBA
Richard Temple wrote in to say: "I'm using Excel as a simple (list) database, with columns as fields and rows as records. I would like to be able to print out all the data (columns) for a record (a row) on a single page by being able to print the columns that Excel wants to print on additional pages on multiple rows instead."
What Richard wants is a kind of row wrap. When Excel cannot fit a complete row on a printed page, he wants the row to continue on a new line instead of spilling over to a second sheet. Excel does not have a single option that will do this, but we have a possible solution.
...