Results 1 to 1 of 1

Thread: anyone?????????????

  1. Mar 16th, 2002, 01:22 PM #1
    ae_jester
    ae_jester is offline

    Thread Starter
    Frenzied Member ae_jester's Avatar
    Join Date
    Jun 2001
    Location
    Kitchener Ontario Canada Earth
    Posts
    1,545

    anyone?????????????

    Hi,

    I have this code which I am using to add a page break to an excel document that I have created through code.

    VB Code:
    1. With excelApp

    2.             .rows(tempRow).Select

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

    4. End With

    I get this message which breaks on the page break line
    "Run time error '1004':
    Application-defined or object-defined error"

    Am I not doing this right? or could something else be causing this problem.

    Any help would be greatly appreciated.
    Last edited by ae_jester; Mar 16th, 2002 at 02:11 PM.


    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