I did get it working. I needed to wrap the range data type as a variant data type because my collection was returning Variant Data types so the range data type addition was failing.