I would just turn on the macro recorder and let it record you entering that formula into an adjacent cell, then copy and EDIT > PASTESPECIAL > VALUE back over the original cell. Then turn off the recorder.
Now you have a VBA version of how to enter that .FormulaR1C1 = into your original code.
As you move that code into your macro, apply the formula to the ENTIRE range. I haven't test the actual formula much, but once you've done as I've suggested above, you get something like this:
As you can see, I'm entering the formulas into column M. You can change that to any empty column out to the right.
Bookmarks