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