Page break Problem...

[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

 

[AlfD]

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

Have you tried this?

Alf

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