On 24 Sep 2005 11:51:20 -0700, "excelnovice"
wrote:

For example if I have data like this:

Eggs
NIL
Ham
Bacon
NIL
Cheese
Salmon
Chicken
Turkey
NIL


I want to use macros to copy the cells which will exclude cells which
has NIL... to give me this:

Eggs
Ham
Bacon
Cheese
Salmon
Chicken
Turkey

How can i do it? The only thing I know here is to use
Range("A1:A10").Copy........ which will always include NIL......


The easiest way without macros is to filter your list using the 'does
not contain' "NIL" option, highlight the range, Copy and then Paste
somewhere else.

If you really want to use a macro then you could get it to do the same
thing.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________