Forum Discussion
Solved
Calling on EXCEL EXPERTS: Simple Macro Produces Varied Results
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...
I'm using Excel 2019 (non-Microsoft 365), version 2104 on Windows 10 Home.
When I run the macro in your workbook, it only affects column B: empty cells are filled with BLANK, and special characters are replaced with spaces. Other columns are unchanged:
I'm using Excel 2019 (non-Microsoft 365), version 2104 on Windows 10 Home.
When I run the macro in your workbook, it only affects column B: empty cells are filled with BLANK, and special characters are replaced with spaces. Other columns are unchanged:
- Thank you Hans!
