I am creating a VBA button to pass info to an Access database. However the
original data contains the single quote in front of each entry. (To ensure a
text entry I'm assuming since this is another databases dump.)
But when I try to do a search and replace on this character from within
Excel, I'm told it isn't found. Even when I cut and paste it into the search
tool! The sheet is not protected.
I need a scriptable solution as this will how all the worksheets will be
provided to me and I do not want to have to translate each to with copy and
paste and new formulas etc.
Any help out there????