* Delete Census and BMD Analysis

[kathjones]

ok if i open visual basic and click run i get

run time error 13 type mismatch

I click debug and get highlighted...

For intloop = 0 To UBound(BMDHeadingsArray) - 1

However if in excel when i 'click to process the data' and it gives me the run time error 9 as before if i click debug it highlights the following error

LogDataError BMDHeadingsArray(intloop) & ' in year ' & CStr(thisEventYear) & ' after latest death', intImportRow

does this help?
kathryn

[hsw]

Do you get the errors if you exit Excel completely, then restart it and reload the spreadsheet?

(If you want to move this to email and spare everyone else our conversation, I'm on colevalleygirl@colevalleygirl.co.uk).

Helen