Excel conditional page breaks

Posted on 2012-03-27
Medium Priority
Last Modified: 2012-07-29
Hi guys, I have a sheet that I need to add page breaks, the range is A4:AG627
If a cell in column CQ is greater than or = 3 then I need to add a page break on those rows
in less than 3 then not page break.

Thank you for your help
Question by:rsen1
  • 2
LVL 41

Accepted Solution

als315 earned 2000 total points
ID: 37775396

Author Comment

ID: 37780023
Thank you for your response. The code I am using is below, I'm inserting this to identify the rows I need to page break. I didn't understand the ozgrid example. I have ten critical page breaks and was hoping for a code that would do it without the ten codes.

If Range("CM242") = "" Then
    Range("A242").PageBreak = xlPageBreakNone
   ElseIf Range("CM242") > 0 Then
    ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
    End If

Author Closing Comment

ID: 38236092
Sorry I forgot about htis question.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question