Variable print area

  • Thread starter Thread starter BOBF
  • Start date Start date
B

BOBF

Can a named print area be DYNAMIC in that it only prints
out the CURRENT number of rows of data? Thanks.
 
I'm new to this but have been trying to solve a similar problem. You can
select the current range region by using ctrl shift and *. So if you move to
a cell in the range you want to print and then use ctrl, shift and * you'll
get a dynamic range for naming or printing.

Hope it helps
 
try something like this
Sub printregion()
x = Cells(Rows.Count, "N").End(xlUp).Row
Range("a1:n" & x).Printout
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto scale print area 3
Printing edge to edge and automatically generating a new page query 3
Print Area to include text box 10
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Excel I have a large (62pages) excel file that needs to be sent as a pdf but it is only exporting half !? 2
email as pdf print area excel 2007 1
Excel2000:How to link Print Area with a named range 5

Back
Top