determining dynamic print area

Pablo

Guest

Posts: n/a

27th Feb 2008

I am working on a print script that will set the print area of a shopping
cart worksheet. I have two worksheets (catalog, shopping cart). A user adds
items from the catalog to the shopping cart. I need the print function to
determine the size of the cart and set and print only the populated range
(A1, J...). The catch is that A1-J23 row being used as the cart's header.
Afterwards, A24 and on is a the cart's quantity column.

Any ideas how to get started?

« How do I clear Print Preview? | clear button »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA to set dynamic print area	cconway365	Microsoft Excel Programming	1	29th Jul 2011 10:50 PM
Dynamic print range using macro and constant print area.	makhanaka	Microsoft Excel Programming	0	23rd Apr 2010 10:36 PM
Dynamic Print Area	Ray	Microsoft Excel Programming	2	31st Aug 2009 05:20 PM
Dynamic Print Area	=?Utf-8?B?SHVkZGxl?=	Microsoft Excel Misc	7	7th Feb 2007 04:55 PM
dynamic print area	=?Utf-8?B?R2VvcmdlVw==?=	Microsoft Excel Worksheet Functions	7	23rd Feb 2006 06:11 PM