You can use the Paste Special/Operation/Multiply feature. Type the
number 10 in a cell. Copy that. Select your entire array that you
want to multiply by 10. Select Paste Special. In the Operation
section of the option box, select the Multiply option and click ok.
That will multiply all of your values by 10. Or, since you've already
got the array with the values, you can copy and Paste Special, select
Values over the original and then delete the array you created to
multiply by 10.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524507