.Copy partial value

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?
 
L

Luke M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application-defined or object-defined error 2
Scrabble Value calculation for Welsh words 0
With F1 value, look at A, if match or partial match return B 5
Copy columns, but not hidden ones 3
want to track time while paste value in multiple column of same roe 1
Calculation of weighed average 6
values not showing for copied formulas 2
If value is then copy 2

Top