Twice is fine. More than twice, consider using an array. If you keep your code short, it's usually more efficient and easier to maintain.
Twice is fine. More than twice, consider using an array. If you keep your code short, it's usually more efficient and easier to maintain.
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'