Ignoring cells with no value

[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

 

[Guest]

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

 

[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

 

[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