Thread: Simple code to find the empty cells in a range and cells with number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default Simple code to find the empty cells in a range and cells with number
Use SpecialCell Method
http://www.ozgrid.com/VBA/special-cells.htm

Some other FUNCTIONS
COUNT
COUNTBLANK
COUNTA
COUNTIF



--
Regards
Dave Hawley
www.ozgrid.com
"Subodh" wrote in message
...
I want to find out how many cells in a given range are empty
Also, since my range can only have numbers in them, it should
also check that the non empty cells do not contain text (only
numbers)
Help to do this in the simplest code possible.

Reply With QuoteReply With Quote