Good morning,
Yesterday, I posted a discussion asking for help regarding a find and replace function I made in VBA. (That discussion can be found here https://techcommunity.microsoft.com/t5/excel/please-help-engineers/m-p/2324107#M98745). What I discovered from my conversation with a couple of users is that one individual running 2016 had success with this function proving my theory that something Microsoft/Excel changed is causing this error. (Thank you @Hans Vogelaar and @JMB17)
Today I am asking for help from the community in running the attached file to see what results you produce. The goal of the function is to find and replace : / \ ? * [ ] AND ALSO if the cell is blank/null fill it in with the word "BLANK." This function should only do this on column B on the sheet "Test 1." Unfortunately, when I run this on my computer the function does the find and replace described above for columns A:E on "Test 1" and Columns A:E on "Test 2."
Although everyone has a different way of writing code...syntax...methods...etc. I know that this code SHOULD WORK as is. I appreciate any suggestions to change the code but am more curious in your results when running this code AS IS on your computer.
If you all don't mind just responding to this post with the version of excel you are running and also what results you achieved that would be awesome! (maybe a screenshot of the data in "Test 1" sheet.
For the record, I am running Version 16.48 (21041102) and the license is a Microsoft 365 Subscription.
