Want to explain this one a little bit more?

"Mark" wrote:

Fairly new to VBA
how do I paste a formula into a macro if the formula relies on cells
embedded into the excel spreadsheet, same row as the range but different
columns?

Thanks