Ok, so I need to check a cell against three known strings for a match, and I've been trying to work out the most efficient way to do it.
I was thinking of using select case with a StrComp statement for each case, something like this:
but I don't actually need the program to do anything if any of the known strings is a match, so the only case that would have any code would be case else.
I imagine this would work, but it just seems kind of inefficient to have "empty" cases just to check for a match.
Edit: attached a small dummy worksheet. What I need is to add all the numbers in column C except those described as "DEPOSIT", "W/D" (withdrawal) or "BALANCE" in column B. The descriptions other than those three mentioned generally look the way I've illustrated, with numbers and special characters, and some may also have a couple letters of text as well.
Bookmarks