Switch text inside cells with another text.
This was needed to correct an bug we presented, we needed to go through large range of cells and replace any H12 found in any of these cells with H14, and at the same time, replace H14 with H12 without doing double replacement.
We could do Find and Replace 3 times, but we were too lazy, we came up with this function instead.
It will return all cells that have been modified so we can check them later.
If SwitchOption = 0, it acts like simple replace function, just replace text in any cell having FindWhat with ReplaceWith
If SwitchOption = 1, then does double find and replace, First replace cells having FindWhat with ReplaceWith, then replace ReplaceWith with FindWhat
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
Views 260
Downloads 102
