xlLastCell will give you the last cell on the spreadsheet. If you want
to know exactly which one that is, open the spreadsheet and hit ctrl +
end.

So something like... range("A11", xlLastCell).Select should work.

Is this what you were looking for?

paqo