Can someone tell me how I can initialise a Range so it defines a (rectangular) region on the spreadsheet? I want to be able to define it in terms of the top-left corner and bottom-right corner or, failing that, the top-left corner and the width and height of the range.

I've been trying to use the Offset and Resize methods of the Range class, but whilst the Offset method works, the Resize method doesn't seem to exist outside of the few examples I've found on the internet.

Thanks in advance,
Barguast