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......