This addresses the Union construction.
Working extract from original code:
The output of the Debug.Print line is as expected:
If you have more than 30 items break them up into multiple sub-ranges and then do a union of the union.
See the following (non-working) code snippet :
When developing the code, make sure the output of the debug.print line contains all the cells in your desired range, and that the range is not truncated.
In your actual workbook, it looks to me like you probably want something like:
Please let me know if I didn't answer your question.
Lewis
Bookmarks