Results 1 to 7 of 7

Macro to Select Changing Print Area

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2010
    Location
    Anderson Indiana
    MS-Off Ver
    Excel 2000
    Posts
    8

    Macro to Select Changing Print Area

    I have a spreadsheet that is constantly changing size. It can grow or shrink. Column A to P only but the rows will be based on only the rows with data. Stop selecting them when they are empty.
    Also Row 1 and 2 are Headers and I do not want them selected as print area. I will be selecting Row 2 to repeat at the Top every time. I do not know if I can include that in the macro to make sure it is done every time.

    I have asked several people to help me with this but every time I have problems. This is for Excel 2000, maybe that is the problem. I can send you the spreadsheet if it helps. The Tab that I perform the macro on will also be changing week by week, so the macro cannot be linked to a specific page or tab. I am not good with macros so need all the help I can get.
    Last edited by alpine4133; 12-17-2010 at 09:36 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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