View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Mahoney Chris Mahoney is offline
external usenet poster
 
Posts: 8
Default 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