Range object containing all cells of a worksheet

Question

I am looking for a command that creates a Range Object containing all cells of a given worksheet.

Sheets(1).Range("A1:AAZ1000000") would be a safe bet, but you never know how many rows or columns you might encounter so something like Sheets(1).Range("All") would be better.

Answer 1

Sheets(1).Cells returns a Range object and when called with no parameters returns a range encompassing all the cells in the sheet.