
Using VBA to select a highlighted range and paste values to another workbook
Hello,
Using the macro record feature does not provide the ability to
highlight cells, then click, go to target location, click, and have
highlighted data pasted in the target area. "I would like the macro to
stay active until I hit the esc key." What I would like is to have the
macro loop through itself until I hit the esc key. So, it would
operate as follows. Highlight cells, click, place cursor on target
cell, click, (values are pasted in), highlight another range of cells,
click, go to next target location, click (values are pasted in) and so
on and so on.
Quote:
> Try recording a macro that copies & then paste special(values)
> >I would like the macro to stay active until
> > I hit the esc key-
> what does this mean-If you mean updating, click again. Otherwise, use
> formulas.
> Don Guillett
> SalesAid Software
> Granite Shoals, TX
> > Hello,
> > Is there some simple VBA code that would allow me to select a group of
> > cells by highlighting it, and then, go to a new cell, in a different
> > workbook, click (right or left) on the target cell and have the copied
> > data pasted in as values? I would like the macro to stay active until
> > I hit the esc key. This would simply a major task.
> > thank-you.