Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Master Excel VBA Printing: Automate Print Area, Sheet Select
Rating: 3.8 out of 5(3 ratings)
221 students

Master Excel VBA Printing: Automate Print Area, Sheet Select

Learn how to automate print area setup, worksheet selection, page orientation, and print preview using Excel VBA
Created byMuhammad Awais
Last updated 7/2025
English
English [Auto],

What you'll learn

  • Set up dynamic print areas to print only relevant data
  • Automate the printing process using VBA macros
  • Print specific sheets, ranges, dynamically
  • Automate batch printing of multiple workbooks and reports

Explore related topics

Course content

1 section • 7 lectures • 35m total length

  • Introduction3:20

    Learn to set the print area from a cell value and preview dynamic ranges, adjusting rows and columns to include or exclude areas before printing.

  • Formula Explanation3:37

    Construct the print area in Excel VBA by building an address with J1/J2 and K1/K2, concatenate them, and apply to G1 through G10, determining orientation from L1 (portrait=1, landscape=2).

  • Applying Code to Different Sheet3:22

    Modify the code to print a chosen sheet by reading its name from cell M2, then use print preview and a macro button to print sheet six's print area.

  • Printing Multiple worksheets Loop10:19

    Automate printing across multiple Excel worksheets using a vba loop that concatenates sheet names and iterates from sheet six to twelve based on the o2 value, with print preview loop.

  • VBA Code Explanation4:40

    Explore a VBA macro that selects sheet one, creates a dynamic print area from m1 via indirect, configures orientation from l1, and opens the print preview.

  • Code Transfer to Other Workbook9:42

    Transfer and adapt VBA print automation across workbooks by copying modules, updating sheet references, and configuring print areas, orientation, and print previews for multiple sheets.

  • End Note0:25

    Wrap up the course by inviting learners to contact for help, request materials, or ask questions about the course.

Requirements

  • No programming Experience Needed

Description

Master Excel VBA: Dynamic Print Preview with Sheet Selection and Loops

Course Overview

Do you want to automate print previews in Excel without manually selecting sheets every time?
In this focused, beginner-friendly course, you will learn how to:

  • Dynamically select worksheets based on cell values

  • Set print areas automatically from your data

  • Adjust print orientation from your worksheet

  • Run a VBA loop where conditions like N2 <= O2 drive automation

  • Generate print previews for multiple sheets or scenarios without manual effort

By the end of this course, you will have a ready-to-use VBA solution that saves you time and reduces repetitive work.

What You’ll Build

A VBA macro that:

  • Reads the sheet name from a cell so no hardcoding is required

  • Sets the print area dynamically

  • Adjusts orientation (portrait or landscape) using a cell value

  • Loops through conditions (for example, N2 <= O2) to automate multiple print previews

Who This Course Is For

  • Excel users who want to improve productivity through VBA automation

  • Office professionals responsible for generating and printing reports

  • Beginners who understand basic Excel and want to learn practical VBA applications

Requirements

  • Basic Excel knowledge

  • Excel 2013, 2016, 2019, 2021, or Office 365

Course Features

  • Short, practical lessons with real-world code

  • Downloadable macro file

  • Step-by-step guidance to build and customize your own macro

Who this course is for:

  • Excel Users to increase their productivity

Report abuse