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 |
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 |