Results 1 to 6 of 6

Set Print Area based on value in specific cell

Threaded View

  1. #1
    Registered User
    Join Date
    12-27-2022
    Location
    Canada
    MS-Off Ver
    365
    Posts
    4

    Set Print Area based on value in specific cell

    Hi There,

    I am trying to create a Macro that will allow me to change the Print Area based on the value in a specific cell. The cell in question is A10, this cell has a dropdown and I would like the print area to change based on the selection. For example if I select "8" from the dropdown I would like the print area to be D4:DK33 but if it is "14" I would like the print area to be D4:GQ33.

    Thank you in advance for any assistance!
    Last edited by LindsPow; 12-28-2022 at 05:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro checking if specific cell is empty every 5 rows, if so- set print area.
    By karajakatak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2020, 07:26 PM
  2. [SOLVED] Dynamic print area, based on cell value
    By countryfan_nt in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-15-2017, 11:53 AM
  3. [SOLVED] Help with print area based on cell value
    By MATT.B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2014, 05:25 PM
  4. [SOLVED] Set Print Area Based on Cell Values
    By maddog9486 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2014, 09:13 AM
  5. Select Print Area Based on Cell Value
    By dzags18 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2013, 03:49 PM
  6. Variable Print Area Macro Based on Cell Value
    By cuclay in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2009, 08:26 PM
  7. dynamic print area based on cell value
    By ritpkg@gmail.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2006, 11:25 PM

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