Thread: Number of rows/columns occupied
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
  
Posts: 527
Default Number of rows/columns occupied
=CountA(A:A)
=CountA(1:1)

"Will" wrote:

Is there a function which counts the number of
rows / columns in an Excel worksheet
which contain something (i.e. are not empty)?


Reply With QuoteReply With Quote