On Oct 8, 7:53 pm, "Bill Renaud"
wrote:
"Calibutterfly",

When your Print macro prints each "Category" and "Consunit" pair, exactly
what gets printed? A range of cells somewhere (where), an entire worksheet
(how is it named?), an external data file (name and folder?), or what? We
need more detailed info to give you any pointers.

--
Regards,
Bill Renaud
Hi Bill,

Thanks for the follow-up. Below you will find the exact ranges for
all of the items.
Print Area = 'SGA Comparative'!$B$1:$Q$142
Drop down list 1 (category) range = 'Date Information' D33:D59
Drop down list 2 (cons unit) range= 'Profit and Loss GC' HX10:HX59
**[the second drop down list could be less than the HX59 range
(meaning 40 items instead of 50) depending on the data to pull in. Is
there anyway to tell it to stop scrolling once it hits a blank cell?]

The two drop-down lists are on the SGA comparative tab. I have a
button created at the top that I usually link the macro to is labeled
as "Print All Worksheets"

Thanks.