SwitchTextinCells

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

CodeFunctionName What is this?

Public

Tested

Original Work

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 Mydevlib.com

Linkedin Login

Range2Loop, FindWhat, ReplaceWith, Optional SwicthOption = 1, Optional InSheet = "Active", Optional InWB = "This"

Views 260

Downloads 102

CodeID
DB ID