Thanks Skip.
The only problem with this approach is that the pages have a given number of rows. It is a report that goes to very senior management and the formatting and pagination is very important. I can't just let the system do that so need to move page breaks to suit.
Appreciate your...
Thanks Andy.
I really should read these things before I post :)
Here is the file I created.
Aspiring to mediocrity since 1957http://files.engineering.com/getfile.aspx?folder=0c95ddbb-45f3-4903-b9d3-45ddf32886a5&file=Excel_Page_Errors.xlsx
Combo, I tried that too. No joy.
Skip, where can I upload a file to? I just created a new workbook with next to no data and the same thing happens.
Thanks for your patience
Aspiring to mediocrity since 1957
Skip,
In response to your last post.
I have 3 pages in Page Break View.
I hide the rows for Page 2
Now I see Page 1 and Page 3 in Page Break View and Page 2 displays a blank page in Print preview.
Andy,
I will try that when time permits.
Thanks.
Aspiring to mediocrity since 1957
No macros but plenty of formulae.
Sorry I can't upload as it is all highly sensitive data and too much to anonymize.
I'll try other stuff.
Thanks for the input.
Aspiring to mediocrity since 1957
Yes, I am in page break display mode
No, the print area is set to print only the columnd I require.
The hidden rows are hidden. Row height is not touched.
I tried removing the grouping and hiding the rows and the same happened.
There are no hard page breaks.
Aspiring to mediocrity since 1957
OK, bad terminology on my part.
I meant that I group rows and hide them. It is the hidden rows that constitute one hidden page - page break at the start and at the end.
Previously means that thid didn't happen last time I did it. Nothing has changed as far as I know.
No, I am printing one...
Hi all,
I have a problem with page numbering and printing.
Long story short...
My Worksheet references others and often a page has no data to print. When this happens I group the rows of the affected page and hide them. I don't delete the rows as I may need it in a subsequent version of the...
>>American 1.5707963267948966192313216916398
Shouldn't that be
American 1.5707963267948966192313216916398.............e
Aspiring to mediocrity since 1957
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.