Excel Crashes

Thanks for your response Carlos. I suspect that the problem is that the file is just too big (although I would have thought that it would also crash on debugging).

I've sent the code to the email above for your attention.

The data in the worksheet is part of a large download from a relational database and contains 4 separate tables, pupils on roll, pupils off roll, attendance data on pupils on roll and attendane data of pupils off roll.

The macro takes the field required from the pupils on roll data and puts it in the output sheet and then appends the equivalent columns from the pupils off roll table. It then adds in both the attendance tables to the 'all absence' sheet.

all of the above runs fine. The problem occurs when the macro copies an array formula down a column of data. This takes place in the do while loop contained in the add_absence macro.