Using VBA to select a highlighted range and paste values to another workbook 
Author Message
 Using VBA to select a highlighted range and paste values to another workbook

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.



Sat, 19 Jun 2004 04:07:38 GMT  
 Using VBA to select a highlighted range and paste values to another workbook
Try recording a macro that copies & then paste special(values)

Quote:
>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


Quote:
> 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.



Sat, 19 Jun 2004 07:43:45 GMT  
 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.



Mon, 21 Jun 2004 12:58:28 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. vba-select multiple disconnected ranges - to copy paste special values in place

2. Selecting ranges in a workbook and pasting into another

3. adding a selected range into SELECT statement using VBA

4. How do I select a constant time range from a variable time range using VBA

5. Pasting Range from Excel 2002 via VBA to Word causes a New Workbook to open

6. VBA print code to select range + pasted chart

7. How do I paste a value from VBA in to a cell in excel workbook

8. Using VBA to paste linked Excel range into Powerpoint

9. Pasting an Excel range as a picture using VBA

10. Using VBA to Import a Range from an Excel Workbook


 
Powered by phpBB® Forum Software © phpBB Group