Hi ;

Dave, your macro is really great. But on the other hand, the problem
is, I still can't find a way to copy the cells and leave the
originals. Could anyone please advise me how to? I have really tried
hard but always get another error message :(

Thanx for your interest.

cop.

<quote
If you didn't mean move, but meant copy (and leave the original cell
alone), there's sample code in VBA's help that will show you how to
keep track of the
address of the first found cell. Then you keep finding the value until
you hit that saved address.


--
coperniqPosted from http://www.pcreview.co.uk/ newsgroup access