| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is there a better alternative to Copy/Paste?
I have a macro which iteratively changes input cells to a formula, and then
Copys and Pastes the input cell value and associated formula result cell value to a list. I use a For Cnt Next Cnt loop to accomplish this. The list is then used as source data for a graph. As a novice VBA user, my question is whether there is a more efficient way to transfer the cell values to the list than copying and pasting? Any advice (with e.g. code) greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there a better alternative to Copy/Paste?
try range("a2:a55").value=range("b2:b55").value -- Don Guillett SalesAid Software "MichaelC" wrote in message ... I have a macro which iteratively changes input cells to a formula, and then Copys and Pastes the input cell value and associated formula result cell value to a list. I use a For Cnt Next Cnt loop to accomplish this. The list is then used as source data for a graph. As a novice VBA user, my question is whether there is a more efficient way to transfer the cell values to the list than copying and pasting? Any advice (with e.g. code) greatly appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is there a better alternative to Copy/Paste?
Thank you, Don, that is most helpful.
"Don Guillett" wrote: try range("a2:a55").value=range("b2:b55").value -- Don Guillett SalesAid Software "MichaelC" wrote in message ... I have a macro which iteratively changes input cells to a formula, and then Copys and Pastes the input cell value and associated formula result cell value to a list. I use a For Cnt Next Cnt loop to accomplish this. The list is then used as source data for a graph. As a novice VBA user, my question is whether there is a more efficient way to transfer the cell values to the list than copying and pasting? Any advice (with e.g. code) greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative copy/delete method needed | Excel Discussion (Misc queries) | |||
| Copy-Paste Alternative Needed... | Excel Discussion (Misc queries) | |||
| How do I paste alternative columns from one worksheet to another? | Excel Discussion (Misc queries) | |||
| formula copy or alternative solutions | Excel Discussion (Misc queries) | |||
| How to delete or copy alternative rows/columns at a time? | Excel Discussion (Misc queries) | |||
Linear Mode
