Quote Originally Posted by LalitPandey87 View Post
In my case there is a particular value :-

e.g.:- "adadfadfad&adadfafa adfasfaf adsfasfasf fdsa&adfa's&adfadfafadfadfadfadf..."


which cause an error.
It might help us to help you if you attached a copy of your workbook with its data and your existing code so that we could see exactly what you see.