| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
.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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
.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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| Partial average | Excel Discussion (Misc queries) | |||
| Partial correlations | Excel Discussion (Misc queries) | |||
| I want to copy partial row to blank row(s) beneath it | Excel Discussion (Misc queries) | |||
| Partial input | Excel Discussion (Misc queries) | |||
Hybrid Mode
