Make page break every several lines automatically by VBA
Hello, is it possible to make page break by counting lines? I've
written a program to create graphs with comments. But every time EXCEL
just separate the page by the length of graphs. What I want is to make
page break between every 39 line and 40 line automatically. For
example, between 39 and 40, 78 and 79...etc.
By the way, the length of the graphs I created changes in a very little
range. But it is only the little change that make me cannot print
correctly.
|