Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    orintation sheet (2000 sr 1)

    I have in foglio1 macro to send a wbook.
    My problem is:

    1) force orintation of sheet sended in orizontal
    2) force a grid
    3) force with autofit orizontal and vertical in base to the print of the user have
    i have only inserted this simple command:

    ActiveSheet.Columns("A:Q").AutoFit
    ActiveSheet.Range("A2").Select

    4) make a control on the sheet TABELLA if user1 or user2 is blank and skip to the subseguent cell...
    In effect for column NOME not all user must have e-mail

    solved all prob for printer status....:-)

    Only the problem in line 4 have many many difficult

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: orintation sheet (2000 sr 1)

    The first 3 can be done with something like this:

    <pre> With ActiveSheet.PageSetup
    .Orientation = xlLandscape
    .PrintGridlines = True
    .Zoom = False
    End With</pre>


    I don't know the italian, but if change those items with the macro recorder going you can get the objects with italian names.

    I don't understand what you are looking for in #4

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: orintation sheet (2000 sr 1)

    With a few exceptions, VBA is the same in all language versions of Office, so the code you posted will work in the Italian or Dutch version of Excel too.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: orintation sheet (2000 sr 1)

    For 4, perhaps something like the attached code. I cannot test it myself.

Posting Permissions

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