Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I searched for 'Dynamic Print Area' and, to my surprise, got
absolutely no results. I can't imagine that I'm the first to ask this, but I've no idea how to re-word it to get results ... I have a worksheet that users need to print every day -- problem is that some days, the sheet could have 3015 lines (or more) and other days, only have 1005 (or less). The number of rows is dictated by how many cashiers worked the previous day, with each cashier entry being 67 lines long. My specific questions a 1) How can I set the print_area to recognize what the bottom row is and set the print_area accordingly? 2) Each page needs to contain all data for just one cashier ... that is, 67 lines per page. Entries start in row 3 ... Good to know info: A) this sheet is actually one of many in the workbook (all will be printed) ... it's just the only one that needs a dynamic print_area. B) users may print from a Button I've inserted OR the default Excel Print button -- ideally, the solution here will work either way. Thanks alot for your time on this ... a successful solution will help save multiple REAMS of paper each day (FYI, I'm attempting to move this to a paper-less solution but our auditors aren't keen on that). Regards, Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Print Area | Excel Programming | |||
Dynamic Print Area | Excel Programming | |||
Dynamic Print Area | Excel Programming | |||
Dynamic Print Area | Excel Discussion (Misc queries) | |||
dynamic print area | Excel Worksheet Functions |