LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default Deleting PageBreaks

Help. I have some code written that first deletes all data in the sheet
(Cells.Delete shift:=xlUp) and reloads the current information from a
database. When I go to format the sheet (using VBA), I noticed that while I
have set the printarea properly, there are vertical page breaks that I need
to remove so I can print all the data (A1:T#) on one sheet.

I have tried "Set Activesheet.VPageBreaks.Location = Range("T#")",
"ActiveSheet.VPageBreaks.Delete", adn even the macro method "DragOff", but to
no avail.

While I can manually go and reset the pagebreaks, I need a way to do it by
code so that if someone adds new sheets, I can add the sheet(s) to the
existing code to automate. Am I missing something?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting PageBreaks Gary''s Student Excel Programming 0 November 16th 05 10:37 PM
Deleting PageBreaks asmenut Excel Programming 1 November 16th 05 05:38 PM
Pagebreaks are not made Jos Vens Excel Programming 7 January 9th 05 07:16 AM
pagebreaks Yiannis H. Economides Excel Programming 1 February 19th 04 04:03 PM
Excel pagebreaks Don Nicholson Excel Programming 0 September 15th 03 05:44 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"