From the code above, could you help me edit this statement Range("j1").Copy Cells(Target.Row, 4) so that it does not copy the formatting, only the value?