Variable print area

B

BOBF

Can a named print area be DYNAMIC in that it only prints
out the CURRENT number of rows of data? Thanks.
 
C

Charles Bennington

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
 
D

Don Guillett

try something like this
Sub printregion()
x = Cells(Rows.Count, "N").End(xlUp).Row
Range("a1:n" & x).Printout
End Sub
 
Top