LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Dynamic Print Area

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Print Area FirstVette52 Excel Programming 5 February 19th 09 03:39 PM
Dynamic Print Area FirstVette52 Excel Programming 0 February 10th 09 07:35 PM
Dynamic Print Area FirstVette52 Excel Programming 0 February 10th 09 07:35 PM
Dynamic Print Area Huddle Excel Discussion (Misc queries) 7 February 7th 07 04:55 PM
dynamic print area GeorgeW Excel Worksheet Functions 7 February 23rd 06 06:11 PM


All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"