I think your solution works perfectly and provides what François
needs.



The key was that you can set a Range equal to an Array.



In your code, calling calcLogOfRange(someRange) will return a Range with the
correct Log values. You can then set another Range equal to this returned
value, and the proper values will appear on the spreadsheet. Or you could
then manipulate the values directly in code.