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

--
Message posted from http://www.ExcelForum.com

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


---
Message posted from http://www.ExcelForum.com/

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 " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

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


---
Message posted from http://www.ExcelForum.com/