Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Print Area
I am creating a spreadsheet, to be completed each month by many suppliers. In
order to make the sheets presentable, and ready to send to my own Client, I'd like each sheet only to print rows that have data in column A. The sheet is set for a maximum of 255 rows, but in some cases, may be s little as 10 rows. How do I set the Print Area to automatically set to the number of rows for each supplier? I have tried using dynamic named ranges, but when I enter these names into Page Setup, it works once, but when I go back to look at the Print Area, it has then been fixed to the result of the named Range (i.e $A$5:$I$20), and no longer referring to the named range. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable - Where have the units/records gone? | Excel Worksheet Functions | |||
Print Area Shifts | Excel Discussion (Misc queries) | |||
print area options | New Users to Excel | |||
Print Area | Excel Discussion (Misc queries) | |||
Can't Clear Print Area | Excel Discussion (Misc queries) |