DataBlake
Well-known Member
- Joined
- Jan 26, 2015
- Messages
- 781
- Office Version
- 2016
- Platform
- Windows
Is it possible to use InStr to where it will only return the position of a string if the phrase you are looking for is the entire cell.
So say for example
InStr(1, a(i, j), "err", 1)
i want to find "err" in an array and not have it return "Sierra"
only if the entire cell is "err" do i want it to return an integer
any known work arounds for this?
So say for example
InStr(1, a(i, j), "err", 1)
i want to find "err" in an array and not have it return "Sierra"
only if the entire cell is "err" do i want it to return an integer
any known work arounds for this?