View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steff_DK[_4_] Steff_DK[_4_] is offline
external usenet poster
 
Posts: 1
Default Count used cells, in a specific range...

I want to count the number of cells in the range 'case' that contain
numbers... (or contains anything for that matter...)


This one gives 'error 6 overflow' maybe because it counts all cells i
the range.

iTest = Workbooks("Projekt
Function").Worksheets("data").Range("case").Count

Thanks

Stef

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