Page break Problem...

  • 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
 
Mr Siddiqui (I think)

You are quoting lines from the Excel VB Help file.

In those lines you copied:
This example sets a manual page break to the left of column J o
Sheet1
Worksheets("Sheet1").Columns("J").PageBreak = xlPageBreakManual
Click to expand...

Have you tried this?

Alf

PS This is either the third or fourth separate posting on the sam
issue. It begins to be confusiing
 
Back
Top