maleodillet
New Member
- Joined
- Feb 15, 2018
- Messages
- 12
Hi Gurus,
I have this requirement where I need to search a Value from a cell [Worksheets("Vol Contri In-kind (budgeted)").Range("E6")] and check to see if it is found within a range [(Worksheets("Vol Contri In-kind (budgeted)").Range("A219:A240")].
If a match is found, I need a variable to contain the string "FOUND" else "NOT FOUND" so then I can read those variable results to continue with the rest of my conditional IF statements executions.
Thanks a lot in advance
I have this requirement where I need to search a Value from a cell [Worksheets("Vol Contri In-kind (budgeted)").Range("E6")] and check to see if it is found within a range [(Worksheets("Vol Contri In-kind (budgeted)").Range("A219:A240")].
If a match is found, I need a variable to contain the string "FOUND" else "NOT FOUND" so then I can read those variable results to continue with the rest of my conditional IF statements executions.
Thanks a lot in advance