Multiply a range

Hi

I have a range of values, and I want to multiply them all by 2. How can I do
this? One idea I had is to copy the range to the clipboard, then fill the
range with 2s and Paste Special Multiply. However, I can't get this to work.

Is there a better way?

Thanks
Chris

One way

Range("IV1").Value = 2
Selection.Copy
Range("A2:A9").PasteSpecial Paste:=xlAll, Operation:=xlMultiply


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris Mahoney" <[email protected]> wrote in message
news:BE44BE1E.142B%[email protected]...
> Hi
>
> I have a range of values, and I want to multiply them all by 2. How can I
do
> this? One idea I had is to copy the range to the clipboard, then fill the
> range with 2s and Paste Special Multiply. However, I can't get this to
work.
>
> Is there a better way?
>
> Thanks
> Chris
>

Type 2 in one single cell, then copy the cell. Select the entire range to
multiply and use Paste Special Multiply.

Greetings,
Bunu

"Chris Mahoney" <[email protected]> schreef in bericht
news:BE44BE1E.142B%[email protected]...
> Hi
>
> I have a range of values, and I want to multiply them all by 2. How can I
> do
> this? One idea I had is to copy the range to the clipboard, then fill the
> range with 2s and Paste Special Multiply. However, I can't get this to
> work.
>
> Is there a better way?
>
> Thanks
> Chris
>

Never mind, someone emailed me with a simple solution which I'm amazed I
didn't think of myself.

Thanks anyway
Chris


On 2/25/05 11:35 AM, in article BE44BE1E.142B%[email protected], "Chris
Mahoney" <[email protected]> wrote:

> Hi
>
> I have a range of values, and I want to multiply them all by 2. How can I do
> this? One idea I had is to copy the range to the clipboard, then fill the
> range with 2s and Paste Special Multiply. However, I can't get this to work.
>
> Is there a better way?
>
> Thanks
> Chris
>

why not share the amazing solution with us.

--
Regards,
Tom Ogilvy

"Chris Mahoney" <[email protected]> wrote in message
news:BE44C3E7.1431%[email protected]...
> Never mind, someone emailed me with a simple solution which I'm amazed I
> didn't think of myself.
>
> Thanks anyway
> Chris
>
>
> On 2/25/05 11:35 AM, in article BE44BE1E.142B%[email protected], "Chris
> Mahoney" <[email protected]> wrote:
>
> > Hi
> >
> > I have a range of values, and I want to multiply them all by 2. How can
I do
> > this? One idea I had is to copy the range to the clipboard, then fill
the
> > range with 2s and Paste Special Multiply. However, I can't get this to
work.
> >
> > Is there a better way?
> >
> > Thanks
> > Chris
> >
>