Noncontiguous ranges printed on one page????

[ajchula]

My boss swears he knows of a way to print noncontiguous ranges on one
page, without using the "copy/paste picture link" method...of course,
he claims he just can't remember how to accomplish this. I say "no
way...can't be done." Is he correct? Does anyone know of a way to do
this? Oh, and without hiding columns or copying data to a new
worksheet...and no macros, either.

 

[Dave Peterson]

I'd insert a new worksheet.
Then select the first range
edit|copy
back to the new worksheet
shift-edit|Paste picture link

Then do the same with the second range.

 

[Ken Wright]

Given all your exclusions, not that I can think of I'm afraid.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Gord Dibben]

Given the constraints listed in your post..........No, it cannot be done.


Gord Dibben Excel MVP

 

[Dave Peterson]

Without..........

Never mind.

I'd insert a new worksheet.
Then select the first range
edit|copy
back to the new worksheet
shift-edit|Paste picture link

Then do the same with the second range.

 

[Ken Wright]

LOL

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------