I want to copy a formula across a range.

theYear = Range("A1") - Range("A3")

range("C4") = ((Range("C7") + 1) ^ (theYear)) - 1

For a specified number across (cellSrc) it will paste the formula which will
be changed to:

range("D4") = (Range("D7") +1) ^ (theYear)) - 1
range("E4") = (Range("E7") +1) ^ (theYear)) - 1

Until it gets to the cellSrc value (an integer that counts the contract term
# of years)

I have no idea where to begin writing a formula that will change
accordingly. Can someone please help me?

Thanks