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.

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.

ajchula wrote:

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

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 :-)
------------------------------*------------------------------*----------------

"ajchula" wrote in message
ups.com...
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.

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


Gord Dibben Excel MVP

On 24 Oct 2005 13:10:02 -0700, "ajchula" wrote:

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.

Without..........

Never mind.



Dave Peterson wrote:

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.

ajchula wrote:

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

--

Dave Peterson

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 :-)
------------------------------*------------------------------*----------------

"Dave Peterson" wrote in message
...
Without..........

Never mind.



Dave Peterson wrote:

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.

ajchula wrote:

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

--

Dave Peterson