Find bottom of Excel worksheet in VBA

Question

I'd like to select to the bottom of the worksheet, but not below what is used/stored. I might have 10,000 rows, but I certainly don't have 65,536. I won't know ahead of time how many rows.

In Excel itself (in recent versions, anyway; Excel 97 wasn't so kind) you can press Ctrl + End to be taken to the last row and column. I'd like the same functionality.

Answer 1

The simplest way is to start at the bottom and work up to find the last row that contains something:
Range("a65536").end(xlup).row

Answer 2

That's elementary:

Selection.End(xlDown).Select

(Found this out by pressing ctrl + end while recording a macro.)