Thread: Count Non Blank Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fredriksson via OfficeKB.com Fredriksson via OfficeKB.com is offline
external usenet poster
  
Posts: 51
Default Count Non Blank Rows
I am trying to count the number of rows in a column that are non blank

Dim NumOfRows
Dim NumOfColumns
NumOfRows = CountA(Sheet1!$A:$A)
NumOfColumns = CountA(Sheet1!$2:$2)

the debugger keep erroring out at this line. Is there anouther function I
can use

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote