Tom’s Tutorials For Excel: Selecting a Large Range Without Scrolling or Dragging.
Here is a handy shortcut tip when you need to select a large range. In the example, I selected a small range of B2:H5 so the pictures can fit onto this web page for demonstration purposes.
But what if you need to select a large range from B2 to, say, HM62000. It would be a burdensome task to scroll down all those rows, and across all those columns, while dragging your mouse from B2:HM62000. There’s a faster and easier way to select a large range of cells.
Brilliant
I would like to select a range that is 100 by 100 cells, starting with the left top corner anywhere on the sheet. How can I do this?
This code line would do that:
activecell.resize(100, 100).select
Maybe I am doing something wrong, but in my case, I would need a way to first find out the cell address of the bottom-right corner.
Is there a trick to doing this? Because for very far-away cells, I would be using my mouse pointer on the scroll-bar grip-rectangle to scroll very quickly and easily overshooting. So I need to solve this problem.
Asdasd
CTRL + END (hold control and press end) will take you to the last used cell of a sheet.
CTRL + * extends out until it hits a blank row and blank column, and highlights the whole region