Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Delete Page Breaks -

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NateBuckley - 23 May 2008 11:30 GMT
Hello, I'm having a little difficulty understanding why the following isn't
working

I have two page breaks on a Sheet that i've added to test this out.

All I want to do at the moment is just make sure that it's finding the page
breaks (as my for each loop wasn't doing anything)

Heres the code

Public Sub removeBreaks()
   Dim brks As HPageBreaks
   Set brks = Sheet7.HPageBreaks
   MsgBox brks.count
End Sub

Now I know I have two page breaks, but brks.Count returns 0, so it's not
returning them. Is there another collection for pagebreaks, or perhaps I'm
neglecting something?

Thanks in advance!

Nathan
Stefi - 23 May 2008 13:31 GMT
Set brks = Worksheets("Sheet7").HPageBreaks
Regards,
Stefi

„NateBuckley” ezt írta:

> Hello, I'm having a little difficulty understanding why the following isn't
> working
[quoted text clipped - 19 lines]
>
> Nathan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.