.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

Create a dynamic master file 1
Application-defined or object-defined error 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Need Help with a VBA subroutine 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Copy columns, but not hidden ones 3
Array with many cells from a row but not in order or together 11
Finding the proper style field and the numbered paragraph value within the style 0

Top