Ok, let me explain the title and the problem. This isn't something that is serious or a requirement to my program, just a
query that if it is availible, I will use.
I have a sheet which gets information passed to it every so often. This
information is added very nicely in a table format. Every week the table gets just a little bit longer, but never any
I would like to be able to print this page as well as the others, but this isn't possible at the minute.
The other sheets fit on one page, whilst this page continues to get longer and longer as time goes by. Since the other pages
fit on one page, a simple "Set Print Area" in the File menu will suffice, and once the margins are set, away we go.
This page that grows each week isn't so simple. I have some text in some cells after the table. Now, this can be deleted if
I modify some other code I am sure, but since I haven't doen that yet it doesn't work. I would like to set the print so that
it will only print the cells I want it to. The cells I want it to print however will change daily/weekly.
The table goes from column A to column J in width.
In length, the table size is undefined, due to the fact that it grows over time.
How can I make the page print
from A to J wide, but as far as needed down?
in other words, I need the Print Area to change when more rows are
added to the table in order for them to all be printed. I want the width to fit one page accross, but it take as many pages
down as is needed.
I do hope this has explained things properly. If not, I will try again.