How can I specify a sheet as range in Excel?
Solution 1:
For MS Office 2007 and later, use
1:1048576
to select all cells in the entire worksheet.
For MS Office 2003 and earlier, use
1:65536
Solution 2:
A quick hack is to click the space above the intersection between first row & first column when prompted for a range to apply to
