View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Multiply a range

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