Ignoring cells with no value

L

louis2112

I am naming certain ranges so I can easily copy them to other sheets
but how do I make excel ignore the cells with no values.

Thanks

Loui
 
C

chris

count function

----- louis2112 > wrote: -----

I am naming certain ranges so I can easily copy them to other sheets,
but how do I make excel ignore the cells with no values.

Thanks

Louis
 
B

Bob Flanagan

Louis you can check to see if a cell is Not empty by a statement like:

If Not IsEmpty(activecell) then
'do copy of cell to destination
End if

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
L

louis2112

Well im trying to do this for a range of cells
To be more clearer.

I want to copy cells A3-A20 and ignore the cells with no value, and
paste them to a different sheet in this process.

Thanks for the help.


Louis
 
Top