Variable print area
 

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

"BOBF" wrote:

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

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


--
Don Guillett
SalesAid Software

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