StupidCoffee
New Member
- Joined
- Jun 11, 2013
- Messages
- 16
Using Microsoft Excel 2007, VBA
I am trying to display an error message if a range is missing '0' or '100', or is empty.
I figured out how to display error when the selected range is empty, but I cannot figure out how to find if a particular value exists within a range and return an error if there isn't.
Please help
Thanks.
I am trying to display an error message if a range is missing '0' or '100', or is empty.
I figured out how to display error when the selected range is empty, but I cannot figure out how to find if a particular value exists within a range and return an error if there isn't.
Please help
Thanks.