snb,


I have no idea exactly what you would use that for. Here, any attempt to get anything meaningful from that drive by snippet of code returns errors or nothing. Thanks just the same.


BREAK


Batman,


I have incorporated your idea of using an array to write the overlay data and then dumping that array en masse in the overlay sheet to the best of my ability. In addition to creating the overlay from the REF_SHEET and NDS_SHEET with all the various conditions (which is working remarkably well thank you!!), there a final wrinkle and condition that until now you were not aware of.


There is an occasional requirement to create "family relationships" between NDS and REF data and display that in 3 addendum columns (Family, Parent and NDS Row Index). To create these relationships, I currently use the CountIf functions to count the number occurrences of a data element. To use CountIf, I have to first write the varOverlay_data into the worksheet. So, when this condition exists, I am once again running the slog of writing data directly to worksheet cells with a corresponding speed loss.


You can see the process and issue in the attached if you have interest. Thanks for all of your help.

Attached Files

Overlay Tool Sample Data BM Ver 1.1.xlsm (287.5 KB, 9 views)

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/