Printing a named range

G

Guest

In Excel 2003, is there a way to print a range by name. For example, I have a
range named "Unit 1" on the same worksheets as named ranges Unit 2, 3 and 4.
Can I print only the named range "Unit 1" without having to select it each
time?

Thanks -
 
G

Guest

the simplest way is to record a macro to select print range and print for
each grouping then set buttons for each macro
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Excel Limit to Named Ranges 1
automatically import multiple named-ranges from Excel to Access 1
VBA - retrieve data on last create named range from previous inserted named range 0
Creating a named range? 2
Named Ranges - Multiple Worksheets 2
Can't located named range 3
Losing a named range 3

Top