Use VBA to check range of cells for non-standard Characters
I have several lists of cells in a single column, some of them have non standard characters in them, and I just want to flag each cell like that. There are usually only a couple in each list, but the lists have several thousand rows each.
Run-time error ‘5’: Invalid procedure call or argument , If the folder name contains quotas
Basically, I am trying to use VBA to search for a string inside word files in a folder and sub-folders.
I found the below macro, But it raises this error if the folder name contains quotas ”
.