Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PageBreak removal

Status
Not open for further replies.
Aeneas

Aeneas

Programmer
Sep 18, 2003
25
CA
This seems simple enough:

Code: 
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell


How about removing one. I don't want to reset all as in:

Code: 
ActiveSheet.ResetAllPageBreaks


I just want to get rid of the one, like:

Code: 
ActiveSheet.HPageBreaks(1).Remove


But this doesn't work. Any suggestions?

Cheers,

Tom
 
Sort by date Sort by votes
Crap -- it's:

Code: 
ActiveSheet.HPageBreaks(1).Delete


Tried a whole whack of stuff, but this seems to work. When I tried this, I don't think I had HPageBreaks[1] set, so got a runtime error, but this works.

Sorry for the waste of time.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vba317
  • Locked
  • Question
Cant set pagebreaks in access 2003
Replies
1
Views
32
SkipVought
S
PWD
  • Locked
  • Question
Insert Pagebreaks - SpecialCells(xlCellTypeVisible) VPageBreaks.Add
Replies
4
Views
46
PWD
PWD
JTBorton
  • Locked
  • Question
Mass removal of macro assignments from shapes 1
Replies
4
Views
35
JTBorton
JTBorton
snowmantle
  • Locked
  • Question
Removal of non-alphanumeric characters but not foreign words 2
Replies
6
Views
56
HarleyQuinn
HarleyQuinn
matrixindicator
  • Locked
  • Question
PageBreak
Replies
4
Views
31
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top