I have an array from A1:ES80 which I want to multiply all cells by 10.

I know I can select another area on the spreadsheet of the same size,
enter
=A1:ES80*10 and press CTL-Shift-Enter to have a new array created.

Unfortunately, this new array is now referenced to the first, and
doesn't let me save just this new array (I am using CSV format so I can
open in graphing/plotting programs).

Is there a way to multiply the original array so i can easily save it?

Thanks!


--
rhauff
------------------------------------------------------------------------
rhauff's Profile: http://www.excelforum.com/member.php...o&userid=32644
View this thread: http://www.excelforum.com/showthread...hreadid=524507