jardenp
Active Member
- Joined
- May 12, 2009
- Messages
- 373
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
The cells in column O can only contain certain values. There is a header in O1 and I'd like to leave that open to changes. So, cells O2:O1000 can be 1, 01, 16, 23, 25, or blank (the "01" would be entered in the sheet as '01 so the zero displays). If they are not one of those values, I would like variable ClassCheck (type Variant) to be set to "N". If there are no cells in column O that are not on that list, I would like ClassCheck to be set to "Y".
I do not want to reference a table of acceptable values--I'd like those values to be in the code.
For example:
<tbody>
</tbody>
Would set ClassCheck to "Y"
<tbody>
</tbody>
Would set ClassCheck to "N" because O3's value is "17" and O5's value is "001", neither of which are on the acceptable list.
Thank you!
Josh in IN
I do not want to reference a table of acceptable values--I'd like those values to be in the code.
For example:
Row | Column O |
1 | ColHeader |
2 | |
3 | 01 |
4 | 23 |
5 | 1 |
6 |
<tbody>
</tbody>
Would set ClassCheck to "Y"
Row | Column O |
1 | ColHeader |
2 | |
3 | 17 |
4 | 23 |
5 | 001 |
6 |
<tbody>
</tbody>
Would set ClassCheck to "N" because O3's value is "17" and O5's value is "001", neither of which are on the acceptable list.
Thank you!
Josh in IN