Try stepping though to code. Use Debug.Print and Watch to see what is happening and identify the errors.
Try stepping though to code. Use Debug.Print and Watch to see what is happening and identify the errors.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'