Help with ranges

[excelerando]

Hi. Ranges in excel have always puzzled me. With my current problem, I want to have a range reference return from two variable cell references. For example:
Given
Sheets...Cells(1,1)
and
Sheets...Cells(2,2)

I want to have returned the equivalent of

Sheets...Range("a1:b2")

My only thought on how to solve the problem was to use nested for..next loops and the union function to add cells to the range one at a time, but this seems a little sloppy, and it seems like there should be an easier/neater way to solve the problem. Any suggestions?
Thanks for your help

 

[excelerando]

I was able to solve this. Thanks.