VBA: Visual Basic for Applications.
It is the programming language used to automate tasks in MS Office programs.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins... sort colors, compare, arrange columns, thesaurus)




"Cosmo"
wrote in message
What is VBA?




"Jim Cone" wrote:
You only have to adjust the page breaks for the sections you are
concerned about. The other pages automatically adjust.

As for setting a fixed amount of rows to print on every page,
there is no way that I know of without using VBA.
With that one could set a manual page break every N rows.

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Cosmo"
wrote in message
I have 50+ pages, is there a way to set a pre detrmined number of cells per
page so I dont have to drag the line on each page?

"Jim Cone" wrote:
Go to the View menu and select "Page Break Preview".
Click and drag the page break lines to where you want them.
Exit by selecting "Normal" on the View menu.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Cosmo"
wrote in message
Is there anyway to set the number of lines in a page break? I have some very
large price sheets with pictures in them and when I set sizing it cuts
pictures where the page breaks end up