I have a emailing list workbook that I use with merge in Word. The complete mail list is on worksheet 1 (500 names/emails), and the following 10 worksheets are the first worksheet divided into groups of 50 each. I used references back to worksheet 1 for all the cells in the 10 workwsheets containing 50 names each, thinking that if I deleted or changed rows/cells in the complete list in worksheet 1 the subsequent sheets would adjust automaticlly. What I find is that when a row is deleted on worksheet 1, I get a reference error in the formulas on the sheet with 50. Is there a way to be able to manipulate the complete worksheet, and have the sheets that refer to it not have errors in the formulas? Thanks for your help. I tried absolute and relative addressing to solve the issue, but neither seemed to work. Thanks

Hi apolloman,

You could use an IF test to validate the formula's output, THEN suppress if an error, ELSE output if valid.

PS: If you used OFFSET formulae for the referencing, no errors would be generated, just 0s - which you could configure your workbook to suppress.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]