Hi,

I've tried both of the following in my VB macro:

Sheet2.Cells(i, 17).Value = Sheet2.Cells(2, 17).Value

and

Sheet2.Cells(i, 17).Formula = Sheet2.Cells(2, 17).Formula

Either way, it sets the value to the value that appears in the cell.
I'll need to copy the formula over. Any advice on what syntax I shall
use? Many thanks!

-Emily