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" wrote in message
...
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" schreef in bericht
...
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 , "Chris
Mahoney" 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" wrote in message
...
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 , "Chris
Mahoney" 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