View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default gicals or formlasCount cells in a Range

if the range is contiguous (and rectangular):

=rows(a1:c9)*columns(a1:c9)

Change the address to what you want.

Gary''s Student wrote:

What is the easiest wasy to count (without VBA) the cells in a range. I want
to count all the cells. Don't care if they are empty, filled with numbers or
text or logicals, for formulas. Just the raw count of cells.
--
Gary''s Student - gsnu2007q


--

Dave Peterson