Hello everybody!
I created some code where I individually compare the cells in a range, checking if at least one of them meets the criteria I'm looking for and I realize that not only does it make my code repeatable, it also makes it bigger.
I would like to declare a range and then check if at least one of your cells fits what I'm looking for.
Examples:
1) check if in Range (A1: E1) there is at least one empty cell;
2) check if in Range (A1: E1) there is at least one cell in which the fill is not white;
3) check if in Range (A5: E5) there is a value other than Blue
4) check if the Range (
If I know how to make this comparison in a range, I will save time and will certainly be more agile.
Thank you in advance, see you next time.
I created some code where I individually compare the cells in a range, checking if at least one of them meets the criteria I'm looking for and I realize that not only does it make my code repeatable, it also makes it bigger.
I would like to declare a range and then check if at least one of your cells fits what I'm looking for.
Examples:
1) check if in Range (A1: E1) there is at least one empty cell;
2) check if in Range (A1: E1) there is at least one cell in which the fill is not white;
3) check if in Range (A5: E5) there is a value other than Blue
4) check if the Range (
If I know how to make this comparison in a range, I will save time and will certainly be more agile.
Thank you in advance, see you next time.