See if one of the canned solutions at Ron de Bruin's site won't work he

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

--
Regards,
Tom Ogilvy


"sylink" wrote in message
oups.com...
I have this problem trying to move a range to another worksheet
For intance I need to highlight and move (also delete leftover blank
spaces) the range containing event column "rev" to sheet 2. The
solution should be able to take any range size (i.e x rows of event
"rev")

SHEET1

NAME EVENT DATE
EUROCOMM VAMB 14/07/2005
EUROCOMM VAMB 14/07/2005
EUROCOMM VAMB 14/07/2005
EUROCOMM rev 18/10/2005
EUROCOMM rev 25/08/2005
EUROCOMM rev 01/08/2005
EUROCOMM rev 28/07/2005
EUROCOMM init 23/12/2005
EUROCOMM init 15/12/2005
EUROCOMM init 14/12/2005
EUROCOMM init 13/12/2005
EUROCOMM init 12/12/2005