Results 1 to 3 of 3

Thread: Detecting Page Breaks in Excel

  1. Dec 14th, 2001, 05:29 PM #1
    Roland_Foxx
    Roland_Foxx is offline

    Thread Starter
    Lively Member
    Join Date
    Nov 2001
    Location
    dev/null
    Posts
    64

    Detecting Page Breaks in Excel

    The saga continues...

    Now I'm trying to write a program to automate filling out an Excel spreadsheet...the problem is that the sheet is multiple pages and the first 9 rows contain header information for when the sheet is printed. Skipping down 9 rows and continuing is no problem, but detecting where the page break is...well, is.

    So, how can I detect where a page break, either hard or soft, is, and whether or not the row I'm on is the row immediately preceding the break?

    Me and my boss both say thanks for any help in advance.
    Reply With Quote Reply With Quote
  2. Dec 19th, 2005, 01:50 AM #2
    mebhas
    mebhas is offline
    Frenzied Member
    Join Date
    May 2003
    Location
    Sydney
    Posts
    1,123

    Re: Detecting Page Breaks in Excel

    try this, no need to check for page breaks.
    My codebank submissions :
    vb6-pop3 attachment processing, vb6-pop3 email

    My Rants:
    Customizing Combobox
    .Net and Office Outlook
    XML, CSV and DataSet
    Using SQL Server Compact in Windows Phone 7.1 apps – Part 4

    My Website : HERE

    Do rate my post if I have helped you.
    Reply With Quote Reply With Quote
  3. Dec 19th, 2005, 10:43 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Detecting Page Breaks in Excel

    Moved to Office Development.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width