I have a program with a large number of calls to INDIRECT.EXT in it (approx
560 rows by 5 columns). On a weekly basis, I need to be able to copy the
contents of the last populated column to the next column to form the basis
for that week's statistics.

My problem is that when I try to do this I continually get the error message

'Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience'

Can anyone advise what is the cause of this and how to get around it?