Evaluate function with R1C1 formulas

Hi folk,
first of all, as I’m new in the forum, I’d like to greet everybody and thank in advance for any help

Shortly my question:
I need to fill a cells range with the RESULT of a formula (NOT the formula itself!)
If I use :

Please Login or Register  to view this content.

It works, but it inputs the formula in each cell, therefore if I apply a long formula to 5000+ cells the worksheet become HUGE!
If I use :

Please Login or Register  to view this content.

Simply it doesn’t work! (#VALORE!)
Any chance I can reach the scope?

Thanks guys

Alex

GREAT!!!

Thank you very much, it does work perfectly!

I’ll use the “with” function which fits my scope 100%; in the example I gave the iteration was accidental and in my case I don’t have any iteration so it works perfectly.

In any case I’ll take in mind also the second solution despite the offset operations are les human friendly to me :P.

Thank you and regards.

Alex