Avoiding reference error on Worksheets

[apolloman]

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

[macropod]

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.