I have in the past referenced ranges in the following way
rng = range(cells(a,b),cells(c,d))
The reason I do it this way is that I know the first cell, I don't know the
last. The "A1" reference does not work for that, unless I were to build the
string on the fly, which seems to be an unnecessary pain.

Problem: this way of refencing a range if very flaky, I get all sorts of
weird errors

Any thoughts?