VBA Code to Force Page Breaks

I

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Hi,
Does anyone know what kind of VBA code I can use to force page breaks? I want page breaks to occur after every 84 rows, but I think Excel's default page breaks get in the way, which of course, I don't want. Thanks for your help!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Forgive me for being lazy tonight; will just post the keywords to Object Browse.

Worksheet.ResetAllPageBreaks
HPageBreaks.Add
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Make a new worksheet at every page break in a worksheet & name each sheet after a value from a cell.
Replies
6
Views
530
Arcomvi
A
A
  • Solved
Automate data export from multiple word tables into excel
Replies
8
Views
271
NdNoviceHlp
NdNoviceHlp
U
  • Solved
Creating Workbooks with Page Breaks
Replies
5
Views
370
UT_CL
U
L
  • Question Question
Page Break VBA Help
Replies
2
Views
420
leila
L
D
  • Question Question
VBA Control Of Page Breaks
Replies
2
Views
2K
DannyDont
D

Forum statistics

Threads
1,225,072
Messages
6,182,697
Members
453,132
Latest member
nsnodgrass73

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top