View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chris Mahoney Chris Mahoney is offline
external usenet poster
 
Posts: 8
Default Multiply a range

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