Dr. Demento
Well-known Member
- Joined
- Nov 2, 2010
- Messages
- 618
- Office Version
- 2019
- 2016
- Platform
- Windows
I understand that I can loop thru .xlCellTypeAllValidation using a For Each loop; however, I'm looking to do things a bit more efficiently, specifically is there a way to group all similar validations into a single range using either .Areas or .xlCellTypeSameValidation. .xlCellTypeSameValidation does this but only once. How do I find ALL the ranges that have the same validations as a composite/Union range??
For example, I create five different validation ranges; if the ranges are non-contiguous, .Areas provides a list of each separate contiguous range. However, it does not discriminate by different validations, even if the two validation ranges are contiguous. I guess I'm looking for a analogous function as .Areas provides for non-contiguous ranges but for data validation. Make sense??
Thanks much, y'all.
For example, I create five different validation ranges; if the ranges are non-contiguous, .Areas provides a list of each separate contiguous range. However, it does not discriminate by different validations, even if the two validation ranges are contiguous. I guess I'm looking for a analogous function as .Areas provides for non-contiguous ranges but for data validation. Make sense??
Thanks much, y'all.