You description is certainly understandable. However, it is so general this
is little that anyone could provide.

Perhaps if you created a collection and then each time you identified a
cell, you added the address of the cell to the collection. Then when you
searched again, you could continue searching until you found something not
in the collection.

Really hard to say without some understanding of your data and what you are
trying to do.

--
Regards,
Tom Ogilvy


"Anton" wrote in message
...
As I must have been unclear in my previous post I'll try again: How can
one
re-size a range object? What I want to do is successively shrink the
range
of cells that are used by a macro that I work on. The macro successively
searches for IDs in a specified range of cells, and if an ID is found then
I
want to remove that cell from the range so that it is no longer part of
further rounds of searching. But as I don't want to modify the worksheet
Range.Delete doesn't work for me.

I'd appreciate any help in solving this problem.

Anton