I've written a macro which formats a table in Worksheet 1. Worksheet 2 is full of formulas that reads from Worksheet 1. But when I add a 'remove duplicate rows' process to the macro, it leaves me with rows in Worksheet 2 that are full of errors.

Maybe to explain better... My workflow is:

1.Copy data (from external table) into Worksheet1
2. Run Macro - "FormatTable".
3. Run Macro "Remove Duplicate Rows"**
4. Check Worksheet 2

The duplicate rows that have been deleted from Worksheet 1 are still in Worksheet 2, but with #REF in each cell. Everything is fine in Worksheet2 after step2. It's step3 that ruins it!

How do I get the 'delete duplicate rows' thing to work on Worksheet2.

** I got this from http://www.cpearson.com/excel/duplicat.htm

cheers!