Hmm.. I'm afraid the situation is a little more complex.

The top of the sheet consists out of data which is taken from
database. This is refeshed every day.

The bottom part of the excel sheet is a range() copy from a histori
sheet to the new sheet.

(file: [Fin001.xls] and historic file [040211Fin001.xls])

It is a macro which copies this data from some 500 files..

Sometimes users make referenses to other sheets within their workboo
when adding notes. When the macro copies the historic information,
get the error I described earlier.

The fields point at an external-file cell, instead of the cell on th
other worksheet.

(For an easy example: I copy rows 50-180 from sheet 1 and 2 from th
historic workbook (with notes) to the workbook with sheet 1 and 2 a
rows 50-180)
I do this for

sd
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message381926.htm