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
> donaldb@281.com
> "MichaelC" <MichaelC@discussions.com> wrote in message
> news:D76ED325-3D36-4E62-A6A1-8A112E22B79F@microsoft.com...
> > 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.
>
>
>

glad to help

--
Don Guillett
SalesAid Software
donaldb@281.com
"MichaelC" <MichaelC@discussions.com> wrote in message
news:046EA72E-7A8E-424D-8ED7-4D08B5275DBD@microsoft.com...
> Thank you, Don, that is most helpful.
>
> "Don Guillett" wrote:
>
> >
> > try
> > range("a2:a55").value=range("b2:b55").value
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "MichaelC" <MichaelC@discussions.com> wrote in message
> > news:D76ED325-3D36-4E62-A6A1-8A112E22B79F@microsoft.com...
> > > 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.
> >
> >
> >