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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> 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