Dynamic Print Range

[putzhead]

Looking for help with a dynamic print range formula. I have data in range A:H and would like to create a dynamic print range based on column D.

 

[Joe4]

I think this will require VBA.

Please provide more specifics on what the range should look like.
What row do we start on?
Are we just looking for the last row in column D with data, or are we to use the information in column D differently (if so, please explain)?

It might be helpful if you walk us though an example of exactly how you would like this to work.

 

[Eric W]

The print range is just a named variable named Print_Area. You can create a dynamic range using OFFSET to get a dynamic range. See here:

Making Print Area dynamic in Excel feat. OFFSET function - How To - PakAccountants.com

Print area is simply the area which will be printed if you give a command either using Ctrl+P or going to File menu and Print. Excel gives you the flexibility to set the print area. We have discussed this feature of Excel way back in time in this article: Excel Tutorial – Ctrl P is Power […]

pakaccountants.com

 

[Joe4]

The print range is just a named variable named Print_Area. You can create a dynamic range using OFFSET to get a dynamic range.

Pretty cool Eric. I did not know that, so I learned something new today!

Hopefully, the OP will be able to incorporate that into their workbook.

 

[putzhead]

thanks Eric, that works!

 

[Eric W]

Putzhead: Glad it works for you!

Joe: There is so much about Excel I still don't know! I'm penciling in 2100 or so to learn it all.

 

[Trixterz]

You can't do this through formula but through VBA with the example code below...

Change D1 to whatever row your cell reference print area is located at in D column.

ActiveSheet.PageSetup.PrintArea = "D1"

 

[Joe4]

You can't do this through formula but through VBA with the example code below...

Look above. Eric proved that you CAN do this without VBA!

 

[Trixterz]

Look above. Eric proved that you CAN do this without VBA!

I totally forgot about the print area in the name managers that you can edit. Cool