Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????
Hi, I am dynamically creating a spreadsheet from contents within another However sometimes the contents in some of the columns is very long When this happens Excel inserts a vertical page break into th spreadsheet automatically (I have none in by default; it's just on page wide). I thought I could override this by placing the following i my vb Code ------------------- Worksheets("Job card").VPageBreaks(1).Location = Worksheets("Job card").Range("M5" ------------------- This is being ignored if the columns are too long and it just fires i a page break whereever it feels appropriate. Similarly I insert horizontal page breaks as you move down the shee with vb also using the following line of code Code ------------------- ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=Cells(intCurRow, 1) ------------------- Where *intCurRow* is the current row number. Lovely works fine 99% o the time however if the number of rows I need to include on one pag exceeds a certain number (69 rows in my case) Excel overrides my v code above and just inserts a page break itself. Can someone please please shed some light on this for me, I presume i has something to do with the ratio of height to width of informatio being displayed??? But can I override it successfully in vb? At th moment I have to go to page break preview and do this manually when have finished creating the spreadsheet which is very annoying This is my first post and it's gonna make or break this forum for m :-) so if anyone can solve this problem for me I'll be gratefull beyon words. Thanks, Lia -- wjoc ----------------------------------------------------------------------- wjoc1's Profile: http://www.excelforum.com/member.php...fo&userid=1528 View this thread: http://www.excelforum.com/showthread.php?threadid=26906 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????
Excel will insert a pagebreak where it must to print the page in accordance
with the print parameters you have specified. If the page will only hold 69 rows, then if you haven't put in a pagebreak before the 69th row, excel will put in an automatic pagebreak. A manual pagebreak can be less than the maximum distance, but if it is more than the maximum distance, an automatic pagebreak must exist. You can use fit to print and specify the number of pages wide and number of pages long or leave one of those blank and it will override all pagebreaks. So perhaps this is the answer for you. -- Regards, Tom Ogilvy "wjoc1" wrote in message ... Hi, I am dynamically creating a spreadsheet from contents within another. However sometimes the contents in some of the columns is very long. When this happens Excel inserts a vertical page break into the spreadsheet automatically (I have none in by default; it's just one page wide). I thought I could override this by placing the following in my vb Code: -------------------- Worksheets("Job card").VPageBreaks(1).Location = Worksheets("Job card").Range("M5") -------------------- This is being ignored if the columns are too long and it just fires in a page break whereever it feels appropriate. Similarly I insert horizontal page breaks as you move down the sheet with vb also using the following line of code Code: -------------------- ActiveWindow.SelectedSheets.HPageBreaks.Add Befo=Cells(intCurRow, 1) -------------------- Where *intCurRow* is the current row number. Lovely works fine 99% of the time however if the number of rows I need to include on one page exceeds a certain number (69 rows in my case) Excel overrides my vb code above and just inserts a page break itself. Can someone please please shed some light on this for me, I presume it has something to do with the ratio of height to width of information being displayed??? But can I override it successfully in vb? At the moment I have to go to page break preview and do this manually when I have finished creating the spreadsheet which is very annoying This is my first post and it's gonna make or break this forum for me :-) so if anyone can solve this problem for me I'll be gratefull beyond words. Thanks, Liam -- wjoc1 ------------------------------------------------------------------------ wjoc1's Profile: http://www.excelforum.com/member.php...o&userid=15281 View this thread: http://www.excelforum.com/showthread...hreadid=269068 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Sheet Ptotection with Overrides to sort | Excel Worksheet Functions | |||
Hmmm, where do I begin? | Excel Discussion (Misc queries) | |||
compute? hmmm. | Excel Discussion (Misc queries) | |||
Hpagebreak help needed please | Excel Programming | |||
HPageBreak | Excel Programming |