Morning - hoping someone can point me in the right direction.
I have a very simple vba script that takes 2 worksheets and compares them, looks for differences, all is good.
The data is coming from an SQL database.
The problem i have, is sometimes one of the cells in SQL contains just a "
If this happens, as expected the rest of the cells all get pasted in wrongly into 1 cell as its expecting a string i guess.
I have the cells set as Text in the cell formatting, this doesn't help.
Any idea, or is this just not possible?
Cheers!
Kev
Bookmarks