I have refered to a range, where I do not know where the end is by
Set rng = Worksheets().Range(Cells(a,b), Cells(c,d)). This tends to be
flaky and I don't want to use the "A1" notation.

Any suggestions?