.Copy partial value

  • Thread starter Thread starter Bishop
  • Start date Start date
B

Bishop

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?
 
Instead of "copying" just state the value as a single equation

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