View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bishop Bishop is offline
external usenet poster
 
Posts: 208
Default .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?