determining dynamic print area

P

Pablo

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Print Area with Dynamic Start Point 2
Macro to control Print area/view 2
Set print area 0
Dynamic Print Area 2
Dynamic Print Area 5
Inserting Control Toolbox text field in Print function 0
Setting Print Area 3
Print Area Range Selection 2

Top