If all these are to be deleted, just do a find and replace for each. Use the Macro Recorder to get the basic code.
If all these are to be deleted, just do a find and replace for each. Use the Macro Recorder to get the basic code.
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'
New thread started for clarity here Attachment also reproduced in that thread!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)