Noncontiguous ranges printed on one page????
 

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.

Noncontiguous ranges printed on one page????
 

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

Noncontiguous ranges printed on one page????
 

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.

Noncontiguous ranges printed on one page????
 

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.

Noncontiguous ranges printed on one page????
 

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

Noncontiguous ranges printed on one page????
 

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