I'm not sure I understand exactly what you want, but I'll try to help  you.

For starters, you seem to want a For loop running backwards (from 7 to
4, instead of from 4 to 7) if this is right, you shold use "For i = 7
to 4 step -1", where the "step -1" part will make it go backwards.

Secondly, the assignation line could be better like this:
Cells(9,2)=Cells(iMyRow-1,4)

The first number within Cells() is the row, and the second is the colmn.

I'm not sure why would you want the loop to start in 7 and use a "-1"
to get the 6, so I set  the loop to start in 6. If I understood what
you want to achieve, the code  should work  like this:

Dim iMyRow as integer

For iMiRow = 7 to 4 step -1
Cells(9,2)=Cells(iMyRow,4)
Next