Aussiebear

If the above is correct then perhaps this might suffice
this is exactly what I look for, but unfortunately your code doesn't work well
for some reason will rename files and ignore others and will skip files in main folder and rename in subfolder .
strangely when try adding words will show me message not found in the specified folder or subfolders!!
despite the original cod in OP will brings files in column B,C so why show me this message?!