View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
 
Posts: n/a
Default count cells in a range

Hi fullers,
If the input range is selected and only in one column then:
Selection.rows.count
returns the number of cells in that range.
Is this what you are after?
Ken Johnson