Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Cell range

Posted by Peter on June 20, 2001 7:41 AM

Is the a way to multiplky a range of cells containing unique values by a constant?
for example columns a thru f refer to months Jan thru Jun
rows 2 thru 6 refer to an item value. If I want to increase the item value by a constant, can I multiply all the individual cells in this range by this new constant.?
Seems there should be, but I may have missed the obviuos.
Thanks for your help
Peter

Re: Cell range

Posted by Mark W. on June 20, 2001 8:45 AM

Yes, enter your constant into an unused cell, Copy
it, select your range, choose the Edit | Paste
Special... menu command pasting Values using the
Multiply operation.

Re: Cell range

Posted by Peter on June 21, 2001 1:23 AM

Thanks Mark
I knew there was someone a lot brighter than me out there

It worked a dream.

rgds

Peter

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.