Macro to Set Print Area and Print Report

**jaredmccullough** · 04-10-2014, 03:39 AM

I am looking to create a macro that dynamically sets the print area based upon the farthest column and last row. The furthest column out with text will be columnJ but the last row is variable to the amount of data put into the worksheet. As well after the first page I would like "Row16" to remain a header row for the rest of the pages. The goal would be to use say "Commandbutton1" to set the print area and print the report.

**adyteo** · 04-10-2014, 04:08 AM

steps:
1. record macro for your steps in defining the print area, selecting header row, and print
2. to get the last row use this code in VBA

Please Login or Register  to view this content.

**jaredmccullough** · 04-12-2014, 12:53 AM

Thanks adyteo

**jaredmccullough** · 04-12-2014, 12:54 AM

Bump for any help in creating the full macro.

**jaredmccullough** · 04-12-2014, 01:21 AM

This is what I got so far: With Custom Margins of .2 Top/Bottom and .25 on the Sides and Set to "Fit Columns to Page" is there anyway I can get this statements in the code so if the user doesn't have the right settings it will adjust?

Please Login or Register  to view this content.

**adyteo** · 04-14-2014, 04:03 AM

if you record the macro when you setup the margins of the page, you will also get the settings.

I have setup (an example) with 5 points for header/footer and 8 points for left/right margins. this is the code oyu need to insert just before ActiveWindow.SelectedSheets.PrintOut

Please Login or Register  to view this content.

Macro to Set Print Area and Print Report

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Set Print Area and Print Report

Re: Macro to Set Print Area and Print Report

Re: Macro to Set Print Area and Print Report

Re: Macro to Set Print Area and Print Report

Re: Macro to Set Print Area and Print Report

Re: Macro to Set Print Area and Print Report

Thread Information

Users Browsing this Thread

Similar Threads

VBA to set print range, open box asking for print qty, print, then redefine print area

[SOLVED] Pivot Table macro to set print area and print details of drill down data

[SOLVED] Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

Create a print macro that would automatically select print area?

Bookmarks

Bookmarks

Posting Permissions