.Copy partial value
 

I have the following code:

(Cells(i-6, "M").Value / 2).Copy Worksheets("Fail Stats").cells(fsstartrow,
"D")

What I'm trying to do is take the value in the cell, divide it by 2, and
paste in the destination. I can't quite get the syntax right though. Or can
it even be done in a single line?

.Copy partial value
 

Instead of "copying" just state the value as a single equation

Worksheets("Fail Stats").cells(fsstartrow, "D") = Cells(i-6,"M").Value / 2

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bishop" wrote:

I have the following code:

(Cells(i-6, "M").Value / 2).Copy Worksheets("Fail Stats").cells(fsstartrow,
"D")

What I'm trying to do is take the value in the cell, divide it by 2, and
paste in the destination. I can't quite get the syntax right though. Or can
it even be done in a single line?