Multiply a range

  • Thread starter Thread starter Chris Mahoney
  • Start date Start date
C

Chris Mahoney

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)
 
Type 2 in one single cell, then copy the cell. Select the entire range to
multiply and use Paste Special Multiply.

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

Thanks anyway
Chris
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiply a range by -1 4
Multiply Corresponding Values in Range 3
Range(sheet2) = Range(sheet1) 11
Is it possible to multiply a chart series formula? 4
Multiply a range by Input Box Value 2
VBA set thick borders around non empty cells in range 0
Code interrupted 2
Verify range is square 5

Back
Top