So you just need to code for multiple cells.

Should each row in the target range have a formula applied?

What is the proper formula?