Excels Gurues ONLY>..

  • Thread starter Thread starter usiddiqui
  • Start date Start date
U

usiddiqui

Hello All.


I am write some code to set page breaks in the generated exce
sheets... i had written the code. to apply horizontal page breaks. no
i just want to ask that can i apply that method. to set the vertica
page breaks also. I dont want to use VPageBreak property, it is givin
some problems to me ...

Please Help . Below is the code that i am writing to set the horizonta
page breaks.



Worksheets("Sheet1").Rows(25).PageBreak = xlPageBreakManual
This example sets a manual page break to the left of column J o
Sheet1.

Worksheets("Sheet1").Columns("J").PageBreak = xlPageBreakManual
This example deletes the two page breaks that were set in the precedin
examples.

Worksheets("Sheet1").Rows(25).PageBreak = xlPageBreakNone
Worksheets("Sheet1").Columns("J").PageBreak = xlNone

Can we apply this method to setting vertical page breaks. .
 
Back
Top