calculation rows by file size can this be done?

  • Thread starter Thread starter Cesar Zapata
  • Start date Start date
C

Cesar Zapata

Hello...

is is possible to calculate how many row exist in column a by just knowing
the file size? it does not have to be exact.

a row means a record for example
1k aprox 5 records

12 k +/- 20 records?

I mean it may not possible but it does not hurt to ask.

;)

thanks,

cesar
 
No. The Usedrange can often appear far larger than it really is, and this can
drive up filesize irrespective of the real number of rows of data. The only
accurate method is to use a formula or macro to determine it. If you know for
sure that your ranges are all just what they should be, then maybe you could
make some educated guesses based on some benchmarks you'd have to identify by
trial and error, but I sure as hell wouldn't rely on them. :-)
 
Back
Top