HOW MANY cells occupied in a Field ???

[medieval]

Firstly, thanks for looking at this - I hope you can help..

I regularly produce a report with 7 fields. Each Field has the same number of records as another.

However each report may differ from next as the number of records produced will vary dependant upon external influences however as I say the the same number of records
exist for each field.

One Field is in a date format and I need to caluclate the difference in days per date for each record. I can do this
quite easily with the function 'datedif=(E2,E3,"d&quot'
however how do I get to copy and paste this down to the last cell if the number of records may vary from one report to another ?

thanks for your help,
Medieval.

 

[xlbo]

lRow = range("A65536&quot.end(xlup).row
Range("F2:F" & lRow).formula = "=datedif=(E2,E3,""d"&quot"

for a formula in col F

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes