Excels Gurues ONLY>..

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top