A little clarification. Ron's site doesn't show the syntax of the copy
statement. The general form is

OldRange.copy Destination:=NewRange

The word "Destination" is not required, but it makes the code easy for
novices to understand.

"dan dungan" wrote:

Hi Patrick,

Have a look at Ron De Bruin's web site:

http://www.rondebruin.nl/copy2.htm

Dan

On Oct 3, 4:51 pm, Patrick wrote:
Hi,

Can someone show me how write a macro that is doing the following;

find a text
select the cells
copy it
paste into another sheet

What is does right now is the following;
find a text
select the cells (A1:B1)
copy it
and past it

But the problem is that the next time the text is located somewhere
else, e.q. A10:B10

So how can I copy this text without setting the cells in the macro?

Reg. Patrick.