Custom views are a useful way to set, all sorts of ways to view your data, including print areas. You can set up a sheet to have several custom views set to print different areas of your worksheet. It would be nice though to be able to set a macro to automatically print the pre-defined print area for you.
Copy the code below into your Visual Basic Editor once for each custom view that you would like to print. Change the words your_custom_view_name to whatever you named your custom view. Note: “macro_name” after the word “Sub” below is the name of the macro, and has to be unique if you have several custom views, but can be whatever you’d like. I would suggest calling each macro something like “print_your_custom_view_name”, so it’s easy to remember which macro to run.
Need help? Use our nifty guide to help figure out how to install and use your macros.