Thread: Size of Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Size of Row

A quick way of doing this is to add an if satement in column B
=if(a1 < "",1)

copy this formular all the way down column b

Then add a sum statement to the botom of column b. the sum will contain the
total number of non blank rows

" wrote:

Hi,

Does anyone know of a quick way of working out how much data a row
contains?

I was hoping to be able to make an estimate of how big a workbook
could get.

Thanks,
Mark