MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Sunil Garg   on Jan 10 In MS Office Category.

Question Answered By: Roop Kapoor   on Jan 10

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

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.



This Question has 7 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on VBA and Arrays/Ranges Or get search suggestion and latest updates.