Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Variable print area
Can a named print area be DYNAMIC in that it only prints
out the CURRENT number of rows of data? Thanks. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
How to Dynamically Set Print Area | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Changing print area | Excel Discussion (Misc queries) | |||
print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions |