+ Reply to Thread
Results 1 to 4 of 4

Shorten Code & clean up

  1. #1
    Registered User
    Join Date
    04-12-2007
    Posts
    57

    Shorten Code & clean up

    I need help cleaning up this code. I am new to VB, but it does work for me. I am trying to have each sheet 6 thru 20 move the vertical page break to the right. It is working this way, however I was hoping to find a shorter code to do all sheets 6-20.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    One way would be a simple loop. This is untested but something like:

    Please Login or Register  to view this content.
    HTH

  3. #3
    Registered User
    Join Date
    04-12-2007
    Posts
    57
    Thank you Richard, it worked perfect. I am new but I am starting to get it....YEAH!!!!

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    If you reset all page breaks, what's the point of the DragOff? Doesn't this do the same thing?
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1