| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied?
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...... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Using Command Button to copy cells | Excel Discussion (Misc queries) | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
