Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 76
Default determining dynamic print area

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?
Reply
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
Print Area as dynamic range? Michael.Tarnowski Excel Worksheet Functions 1 March 8th 09 04:02 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
Vb to set print area for dynamic pages Tedd N Excel Programming 4 February 8th 06 04:25 PM
Dynamic print area Harley Excel Programming 3 November 10th 05 01:11 PM


All times are GMT +1. The time now is 05:24 PM.

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

About Us

"It's about Microsoft Excel"