View Single Post
  #3   Report Post  
Don Guillett
 
Posts: n/a
Default

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.