Hi Kelly, you are very welcome. Thanks for the feedback ... very positive !


"Kelly" wrote in message
...
A million thanks Trevor! Cheers :) Kelly

"Trevor Shuttleworth" wrote:

Kelly

press F5 (GoTo) and then select the range name (consolidated).

Now press Print and choose "Selection"

Use Preview to make sure that you will print what you want.

Regards

Trevor


"Kelly" wrote in message
...
hello -

Isn't one able to create a name (range) in a spreadsheet then print
that
specific area without having to reset the print area each time? for
example,
if I set a1:f70 as a named called "consolidated", can't I then select
"consolidated" and just print that area? If so, how do I go about
setting
that range?

Thank you!
Kelly